Using Property Control to toggle between Sum of sales and % of Total

[David Law 2]

I have a cross table which I want to toggle between the sum of sales (currency) and the % of total using a property control.

I can only get the property control to work with the sum of sales, but couldn't seems to figure the right expression to use for the % of Total.

The default expression below for % of Total from the cross table doesn't seems to apply to the property control

Sum([sales]) THEN [Value] / Sum([Value]) OVER (All([Axis.Rows])) as [sales in Percentage]

Please refer attached image for more details.

How do I get the property control to work with both the sum of sales and % of total

Thanks.

[Gaia Paolini]

The results on the image look right, if you wanted the percentage for each quarter, which seems appropriate since you are showing 100% for each column at the bottom.

 

Was this the desired outcome or the outcome you are currently getting