Hi All,
I have a pivot table. What I need is if there is any kind of macro that can change the filters just like the excel sheet and then back to pivot table filters.
The reason being for this kind of change in filter is that I have prepared a sheet which gives you the money spent by customer after using some search critirias! Now my boss wants to sort that result in ascending, descending and top 10, bottom 10 etc, similar to that what is present in excel sheet filters.
Please help me!!!
Thanks in advance!!!
I have a pivot table. What I need is if there is any kind of macro that can change the filters just like the excel sheet and then back to pivot table filters.
The reason being for this kind of change in filter is that I have prepared a sheet which gives you the money spent by customer after using some search critirias! Now my boss wants to sort that result in ascending, descending and top 10, bottom 10 etc, similar to that what is present in excel sheet filters.
Please help me!!!
Thanks in advance!!!
