Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a pivot table (the first one) with the following dimensions: Location, Dimension and Line and three expressions:
1. The Total Amount by dimensions
2. %: the percent between each line and the R line.
3. AVG %: the percent between each line and the R line but without location selected.
I made the first and the second expressions.
One problem is that the second expression isn't calculated at the Total, and the biggest problem is that I can't make the third expression to ignore the location. The AVG % should be exactly like the AVG % from the second table, no matter what location is in the first table.
I attached my qvw file.
Can you help me?
Thank you!
Hi, for 2nd expession you can use:
=sum(Amount)
/sum(TOTAL <Dimension,Location> {<Line={"R1","R2"}>} Amount)
And for the 3rd:
=sum(TOTAL <Dimension, Line> Amount)
/sum(TOTAL <Dimension> {<Line={"R1","R2"}>} Amount)
Hi, for 2nd expession you can use:
=sum(Amount)
/sum(TOTAL <Dimension,Location> {<Line={"R1","R2"}>} Amount)
And for the 3rd:
=sum(TOTAL <Dimension, Line> Amount)
/sum(TOTAL <Dimension> {<Line={"R1","R2"}>} Amount)
It's working. Thank you!