Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to suppress a dimension when the value is null and have an expression that calulates a percentage and the total of that percentage adds up to 100.
See the example below.
Person | Sales | % of Total Sales |
---|---|---|
Sam | 10 | 10% |
John | 25 | 25% |
Mark | 50 | 50% |
TOTAL | 85 | 85% instead of 100% |
--in this example, there are 15 sales that are 'null' and I don't want to include. However, I still want the % to add up to 100 when I suppress null values
It seems I don't understand how you calculate your % from the sales values (not even the detail lines).
Could you explain how your calculation works?
Or post a small sample QVW?
Or maybe your sales are not NULL, but the dimension Person these sales are linked to?
What about
=Sum(Sales) / $(=Sum(Sales))
Check the box Supress when value is Null in the Dimensions tab! Try like this as attached.
Updated!
hi
use this expression to calculate the share
sum(Sales)/sum({<Person=p(Person)>}Total Sales)
Thanks everyone, I was able to figure it out with all of your help!! Sum(Sales)/$(=Sum(Sales) worked!!!!