I have a set of several metrics' sheets with multi-year tables of data where columns are for months (and weeks if user wants to go with that?) because there's 15k+ rows of products, which are always in the same order throughout all the sheets (same with weeks/months, ofc). I'd like to be able to present the data through several pivot charts all dependent on one pivot table within the data model where I can slice through 1 slicer for months, another for weeks and 1 slicer for the different metrics (amount of buyers, revenue, net revenue, etc); extra points, there's a combined product category which is always the top ranked, I'd love to have a slicer for "with" "without" combined prod. IE:

Sheet1: ProductBuyers

Product Name/Key                        J18 J18 J18 J18 F18 F18 F18 F18 
                                        W01 W02 W03 W04 W05 W06 W07 W08
Combined products                       26  26  31  31  33  31  26  31
Bread, white, large loaf                11  11  11  16  8   0   0   8
Bread, white, industrially packed, WKB  10  4   0   0   2   0   0   1
Bread, white, toast, large pack, WKB    10  8   9   8   7   6   0   0
Biscuits, chocolate chip cookies, WKB   10  7   6   11  9   0   0   9
Biscuits, wafers, WKB                   6   0   0   0   0   0   0   0
Biscuits, salted crackers, WKB          6   5   0   0   0   0   0   0
Crispbread, Swedish type, SB            5   7   5   6   6   0   0   3
Pizza, frozen, SB                       4   4   3   5   5   0   3   7
Pasta, without eggs, WKB                4   2   2   2   2   0   0   0

Sheet2: ProductRevenue

Product Name/Key                        J18 J18 J18 J18 F18 F18 F18 F18 
                                        W01 W02 W03 W04 W05 W06 W07 W08
Combined products                       $2,876  $3,708  $4,671  $6,304  $5,877  $4,085  $4,062  $4,736  
Bread, white, large loaf                $714    $731    $811    $1,798  $538    $0  $0  $768        
Bread, white, industrially packed, WKB  $576    $147    0   0   $89 0   0   $39                 
Bread, white, toast, large pack, WKB    $5,009  $3,116  $4,289  $4,777  $5,081  $1,826  0   $0                  
Biscuits, chocolate chip cookies, WKB   $1,041  $284    $312    $1,245  $1,819  $21 $0  $953                    
Biscuits, wafers, WKB                   $1,245  0   0   0   0   0   0   0   
Biscuits, salted crackers, WKB          $1,970  $341    0   $0  0   $0  0   $0          
Crispbread, Swedish type, SB            $636    $602    $357    $614    $868    0   $0  $258            
Pizza, frozen, SB                       $268    $302    $119    $422    $1,089  0   $401    $851
Pasta, without eggs, WKB                $276    $83 $84 $46 $75 0   0   0

0 Answers