I have an SA Pivot table that shows total revenue for accounts. What I need is to have columns that combine accounts to get the total revenue of those 2 columns.
For example:
For account 4100 I have total revenue of 11,000
For account 4403 I have total revenue of 10,000
For account 4500 I have total revenue of 21,000
For account 4803 I have total revenue of 10,000
I need 2 columns on my pivot:
Column 1 - total of 4100 + 4403
Column 2 - total of 4500 + 4803
Is this possible