Hi all,
I have a somewhat large table (close to 1M rows) that I'm trying to analyze using a Pivot Table. The rows section shows me the customer ID and the values are the project volume amongst other things. I created a really nice looking interactive dashboard and i was was wondering if it was possible to use slicers to filter a pivot table by any of the value filters?
My first approach was the following:
I created a helper table on another sheet, which simply contains a series of values (starting from 0 to 500k in 100k steps) and a name. The value names are simply used for the slicer for aesthetic reasons. For the helper table I created a slicer so that I can filter the values.
Then I created a measure in the actual customer table, which gives me the MIN value from the helper table
and a second measure that only shows values if greater than the MINHTML Code:
Two problems with this approach:HTML Code:
1. the MIN function shows me the MIN value of the helper table not only for the visible values (even if it is filtered, the MIN value remains 0)
2. the actual table does not react and does not update itself from the helper table after using the silcer
Can anyone tell me if this is generally possible? Where is my thinking error? Is there possibly a smarter approach to reach the goal?
I am grateful for any advice
Bookmarks