If statements and aggrigates

[Anonymous]

I have a pivot table with customers, then data set type.

Each month we receive data from these customers of various data set types. I want to have a gauge to show that we've received last month's data ok for each customer, and each data set type that we've received before.

I have this as the expression in the pivot table:

if(Max({<Indirects.Year={$(=Year(AddMonths(Today(), -1)))}>} Indirects.Month) = Num(Month(AddMonths(Today(), -1))) And   Max(Indirects.Year) = Num(Year(AddMonths(Today(), -1))),1,0)

This works ok when drilling down to the detail, but if I collapse the data set type dimension then I get "1" if any of the data sets are ok, rather than if all are ok.

What I want is a "0" for the customer row if any data set type row has a "0".

How can I do this?