Pivot table based on a pivot table table

[shophoney]

Hi, is it possible to create a pivot table based on the results of another pivot table.

I have an inventory table that has items and a measure that calculates slow movers and fast movers based on how many units are sold each week.

I then pull the information from the powerpivot table into a table currently and copy the results to a new table. Then I filter the results to SLOW or FAST.

I cant put a slicer in as the results are based on a measure. And you cant run slicers based on measures.

Any thoughts on how to do this best.

Thanks

 

[VBA Geek]

I cant put a slicer in as the results are based on a measure. And you cant run slicers based on measures.

Have you tried adding a Calculated Column which performs the categorization between SLOW and FAST ?

 

[shophoney]

Have you tried adding a Calculated Column which performs the categorization between SLOW and FAST ?

Hi, I cant use a calculated column as the measure is based on the total sales for all units within the style.

I first need the total sales for all sizes and colors within the style.

 

[VBA Geek]

Could you post a sample table with expected results ?