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
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
