Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Two Pivot Tables with Different Values — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Two Pivot Tables with Different Values




I am trying to contain a report that has two pivot tables in it but with different parameters to restrict the results. I am pulling in the Expenditure Type column and want to restrict it by Expenditure Category. I want one table to show Expenditure Types by the 'Labour' value from Expenditure Category and the other table to show Expenditure Types without the 'Labour' value. Now, I can do this but only for one table, if I create another table it automatically restricts it to 'Labour' and if I change it then it changes table 1 to whatever I have changed

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!