Forum Discussion
Referencing list Of 10 Customers By Sales Value For A Prodcut
Hi All, Could someone please advise what is the right formula for me to achieve my objectives here. From the raw data I have 3 columns, A for customers B for products C for sales I would ...
Can I ask why you don't want to use a Pivot Table?
I've attached one approach using AGGREGATE and it's Large function coupled with a Slicer for the Data Table. The AGGREGATE function can be used to ignore hidden / filtered rows, so when you apply the slicer it calculates the Largest value based on the visible cells