David Law 2 Posted May 17, 2021 Share Posted May 17, 2021 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. Link to comment Share on other sites More sharing options...
Gaia Paolini Posted May 18, 2021 Share Posted May 18, 2021 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now