Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using a cross table which has quite a few expressions in it, the last expression is a total column which I would like to display the actual amount of something, and it's % of the total.
There is also a subtotal row, so the very bottom right box is the subtotal of the total column.
So for example if the last column's values were:
10
50
40
100
where 100 is the subtotal, I would want it to display as:
10 (10%)
50 (50%)
40 (40%)
100
Any tips on using the dual function to accomplish this?
IF(Dimensionality()=1,SUM(Value) & ' ' & NUM(SUM(Value)/SUM(TOTAL Value),'#,##0.00%'),SUM(TOTAL Value))
Or
IF(Dimensionality()=1,SUM(Value) & ' ' &'('&NUM(SUM(Value)/SUM(TOTAL Value),'#,##0%')&')',SUM(TOTAL Value))
Hi Stephan
Dual seems to be the proper solution. Probably in combination with Dimensionality() function.
Please upload your example if you want the solution
Lukasz