ShadowRider
New Member
- Joined
- Sep 23, 2010
- Messages
- 23
- Office Version
- 365
- Platform
- MacOS
- Web
Hello,
I'm trying to assist my wife in some calculations. She gets months reports regarding patients and specifics about procedures completed and discharge location.
She is needs to be able to calculate different percentages of a subset of the above and I'm not sure the best way to do it. Currently she uses a pivot table with some filters to determine the base amount, and then a second pivot table based on the same data with the original filters plus a few more, and then calculates the percentage this second table's result is of the first table's results.
Is there a better way? Can this be done in a single pivot table?
Due to hipaa rules I can not post her data for examples but if its not clear, I can perhaps generate some fake example data.
Thanks,
-Eric
I'm trying to assist my wife in some calculations. She gets months reports regarding patients and specifics about procedures completed and discharge location.
She is needs to be able to calculate different percentages of a subset of the above and I'm not sure the best way to do it. Currently she uses a pivot table with some filters to determine the base amount, and then a second pivot table based on the same data with the original filters plus a few more, and then calculates the percentage this second table's result is of the first table's results.
Is there a better way? Can this be done in a single pivot table?
Due to hipaa rules I can not post her data for examples but if its not clear, I can perhaps generate some fake example data.
Thanks,
-Eric