Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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