If Statement in Measure & Dimension Values

[NormanStanleyBadger]

Hi,

Using a pivot table, I have an If statement that returns a Measure for cumulative sales based on month. Within the Measure returned, I have a set analysis filter for the select group of customers that I would like to show on the Pivot.

The measure is returning the correct numeric values, however, when I add the "Customer Name" dimension it returns all customers rather than just customers filtered for in the Measure's set analysis. 

How do I correct this behaviour, so that I only get the customers filtered in the set analysis?

Thanks.

[Or · Accepted solution]

Assuming you are not displaying zero/null values, and assuming this is the only measure, this should happen automatically if your formula is written "correctly" (with the if() statements inside the aggregation functions).