Hello all,
I am trying to use PivotTables to summarize and filter data. I have various tables that all do what I want, except for one.
I have a list of RMs (People), their Units Under Management, and Total Claim Cost per RM. Some properties have multiple claims, thus repeating data such as Unit count.
(A property with 100 units might have 3 claims, making the PivotTable display 300 units.)
Is there any way to make a PivotTable sumdistinct, or something similar, to display the RM, their units under management (counting the units for a property only once), and their total cost?
The reason I want this information is to simply divide the total incurred by units for a claims per door column. Currently it would be using inaccurate unit numbers unless I create another data set.
Please advise if you know the solution off the top of your head. Thank you very much.
Please see attached for the excel file with data and examples.
Problem Example.xlsm
Screenshot 2022-08-17 111818.png
Bookmarks