Hi Everyone
I am stuck with one report, basically i was trying to add pivot table for sale report. I need 2 tables, one is category report, by adding Category and Date in filter and second one is Top 10 sales , by adding Category and Date in fitter. Both i did it in attached file.
But is that possible have only one report filter, if i selected category then Top 10 and Category table has to changes and also i need to select From and to date in report filter. If not possible can we do it in VBA, i heard we have similar option, anyone guide me
I am stuck with one report, basically i was trying to add pivot table for sale report. I need 2 tables, one is category report, by adding Category and Date in filter and second one is Top 10 sales , by adding Category and Date in fitter. Both i did it in attached file.
But is that possible have only one report filter, if i selected category then Top 10 and Category table has to changes and also i need to select From and to date in report filter. If not possible can we do it in VBA, i heard we have similar option, anyone guide me