Hi Forum, I have a simple power pivot table summarising clients and sales amounts. Adjacent to the pivot table, I have set up two columns - a vlookup returning the corresponding account manager for a client, and a status column (if formula to numerically classify sales amount, with conditional formatting icons applied).

I would like to effectively "merge" the pivot table and my columns as one sortable table. Should I be using getpivotdata to create a new table, or is there a better way to achieve this? Thank you.