Jump to content

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

David Law 2

Recommended Posts

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


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...