Suppress when value is null chart issue

[#1]

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

[swuehl]

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?

[swuehl]

Or maybe your sales are not NULL, but the dimension Person these sales are linked to?

[swuehl]

What about

=Sum(Sales) / $(=Sum(Sales))

[vishsaggi]

Check the box Supress when value is Null in the Dimensions tab! Try like this as attached.

Updated!

[lironbaram]

hi

use this expression to calculate the share

sum(Sales)/sum({<Person=p(Person)>}Total Sales)

[#7]

Thanks everyone, I was able to figure it out with all of your help!! Sum(Sales)/$(=Sum(Sales) worked!!!!