Help using "Dual" function to display 2 values in a single column

[#1]

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?

[MK_QSL]

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))

[#3]

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