Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am building a pivot table and I had created some alt states so users can compare their sales by customer and sales part by their own custom current and prior period.
while that would seem to work ok, it will not allow me to filter down my table when a specific customer is selected.
In this small example pictured below, I want to be able to select a time period, and then see only customer C if i wanted to, just like I could if alternate states were not applied.
