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.