Pivot Table and dimension

[filippo]

Hi Community,

I have a problem with pivot table with 2 dimensions: Customer, Year

and 1 expression: SUM(NET)

I would like to see only the customers who have values in all the years.

How can i do?

Thanks

[mike_garcia]

Hi,

I have not tested this one, but it might do the trick.

sum( {$<Customer = {"=count(aggr(Sum(NET), Year)) = max(Year) - min(Year) + 1"}>} NET)

Let me know it it helps.

Mike