Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you need any additional information for this? I'd appreciate any and all help!
Thanks in advance,
Claire
Hi Claire,
Can you upload an example?
Thank you!