Custom grouping in excel

[boooinky]

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,

[Pecoflyer]

Hi

first add a helper column with the formula =left(names,1)
then select your source ( including the helper column) and click "Insert table" - Change the name as required
use this table as source for your PT using the helper column as the first row field
each time row(s) are added, the table will adapt and the formula follows automatically
You just need to refresh your PT