Adding a "tag" to my pivottable

Hi all

I have a problem. I want to add an additional column in my pivottable to categorize whether the different types of data are 'Other "billable work"' , 'Admin' or non-work.

As you can see the different types should be linked to the different types of work.

After that I want to make a chart, showing the different allocations.

I don't have access to the source data, so I cannot do anything about that... It just keeps updating

Anyone can help?

Best regards Henrik

You indicate you do not have access to the source data, but it must be available at some point to generate the pivot table.

Where is the relationship between the Work and the Types? Is this in a system somewhere or does it manual? How will you maintain this relationship?

Possible options
1. Add a column to the source data that uses a lookup to map the Work to the Type
- depending on how you refresh your data this might need to be updated each time
- using a Table to hold your data might help with this
- need to create and maintain the lookup table
2. Use Power Query to bring in the data from the source, and Merge that with a lookup table to get the Type