My Situation:
I have 1 dimension that returns 4 results.
Second dimension I set to show partial sums.
So now I have the results of:
A
1
2
Total
B
1
2
Total
C
1
2
Total
D
1
2
Total
I need to be able to create different formulas for the different dimension totals.
Example:
No A total needed.
B Total needs to be the total of A and B
C Total needs to be the totals of A, B and C, but NOT A1
D Total needs to be the totals of A,B,C, and D, but NOT A1
I then need to have the total of total fields which I could have set to dimensionality()=0
Example:
Total of A,B,C,D
Any one have any ideas?