Same Data Source, Isolated Pivot Tables

drewg

Board Regular
Joined
Jul 5, 2010
Messages
67
I have a data source that needs to be reported by the dimensions
in network vs out of network
facility vs nonfacility vs specialist
billed amount vs paid amount vs eligible amount
membership by line of coverage

The result is a giant union of many third party administrator claims. at first, i tried to get this all into one pivot table, but then i created a second pivot table based on the same data source, the problem is that when i set filters on the first pivot table, it affects the second one too.

Can i use two pivot tables against the same million records and have them independently filter the data so i can create the one giant consolidation report so i can divide in network by total billed or out of network by total billed?
i think im suffering from two different levels of granularity, totals and subtotals that i need to make ratios, but cannot get them to materialize on one pivot table.

thanks for any light you can shed
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,122,962
Messages
5,599,065
Members
414,281
Latest member
Engjamal2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top