Calculated Dimension and Total

[#1]

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

[#2]

Do you need any additional information for this?  I'd appreciate any and all help!

Thanks in advance,

Claire

[#3]

Hi Claire,

Can you upload an example?

Thank you!