Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I've a pivot table and it gives the sales by supplier and by store like the image attached.
I can show the total sales by both store and by supplier. How to show the count of stores where the sales value is zero.
Regards,
Viresh
Have you tried to use set analysis?
Maybe something like this: Aggr(Count(<{Value=0}>),Supplier)
Hi, The stores will vary but i need the expression as part of the pivot table. Thanks