I have a pivot table which is linked to a dynamic worksheet.
I want to group the contents of the pivot table based on a filter e.g "all names starting from "A" come under the category A group in the pivot"
How should I go about doing this?
When it comes to grouping, I know that I can manually select the relevant records but since my data set updates dynamically I want a filter to group automatically each time I refresh the data
Regards,