1 Reply Latest reply: Jun 6, 2011 9:34 PM by Erich Shiino RSS

    Calculated Dimension help

    Peter Delvito

       

      Hello All,

      I don’t have access to my qvw script however, I am trying to create a calculated dimension that uses a flag (Y/N) to determine a qualifying category based off the Customer. I want to be able to look at the customer in a table and use the Qualifying Category to sum revenue. Here how I want the qualifying catergory to look like.

       

       

       

      Customer,Flag,Category,Revenue,Qual_Category

      1,Y,A,100,A

      1,N,B,50,A

      2,Y,C,100,C

      2,N,D,50,C

       

       

      I am able to use an if statement for the first true condition if(Flag=’Y’,Category, but trying to get the match based off of the customer is where I am having issues. Thank you