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
 

Forum statistics

Threads
1,085,992
Messages
5,387,141
Members
402,045
Latest member
Hidalgo

Some videos you may like

This Week's Hot Topics

Top