This content has been marked as final. Show 6 replies
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|
|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