It is possible to put a subtotal inside a dimension?
I haven't posted anything in a while, now I'm seeing this new forum design... is great!!!
Now, to what matters:
In the attached file, you can see that I have already designed a Pivot Table with results of certain indicators in several categories. But as a requirement from my employeers, I need to put a subtotal row only for certain categories that should not affect the total result. Is there any way to accomplish this?
I guess my question should be better understood seing the attached file.
What I need to do is the following: The total "D" is not the sum of all rows but corresponds to SUMPRODUCT (C2: C9, D2: D9) / SUM (D2: D9), and the totals for "A", "B" and "C" correspond to the sum of their ranks.