Hey Folks,
Wondering why my pivot table, which draws from a cube (OLAP) source, isn't filtering on the true top 100 customers we have!
The pivot columns are months (August 2017 through July 2018) and the rows are individual customers.
My value filter is set to customers, filtering by "top 100 items by total cost." But the total cost is filtering on the final column only (july 2018) instead of the entire date range.
What gives?
Wondering why my pivot table, which draws from a cube (OLAP) source, isn't filtering on the true top 100 customers we have!
The pivot columns are months (August 2017 through July 2018) and the rows are individual customers.
My value filter is set to customers, filtering by "top 100 items by total cost." But the total cost is filtering on the final column only (july 2018) instead of the entire date range.
What gives?
