2 Replies Latest reply: Nov 8, 2011 5:13 PM by Gabriela Morales RSS

    Calculated Dimension and Total

      Hi All,

       

      In a pivot table, I'm trying to calculate the total in one of my expressions by ignoring one dimension (Dimesion 1) and grouping by the other (Calculated Dimension 2).  Any suggestions for how to do this?  I know the usual formula for this would be Sum( total <[Dimension 2]> widgets), but I can't figure out how to get it to work.  I don't think I can build the calculated dimension as a variable or hard code it either- it adjusts based on input boxes in my file.

       

       

      Thoughts?

       

      Thanks for your time,

       

      Claire