PDA

View Full Version : Formula instead of Pivot Table



kamalmalek
10-17-2018, 11:04 PM
Dear Supporters,
may can help me for attached file:
i did pivote table to select top 30 items and sales by stores "with option to select date and section"

i need to do same in another sheet but with formula "with option to select date and section"










?


Day
1


DP
MKT


item Description
BBB


?



?



?



?



?



?



?



?







THANKS

Rob342
11-02-2018, 07:38 AM
No need to code this add 2 Pivot slicers for the information you want to extract from the pivot its a lot easier than coding as it does all the work for you and its faster.