Formula instead of Pivot Table

[kamalmalek]

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]

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.