Question 1: I am running into an issue with the partial total in my pivot table in the attached file. The issue is related to the "Adjusted Reimb" and "Opportunity". These totals do not have the correct total. Can anyone provide guidance on the correct formula to get this to work? I will need the correct subtotal to show up when collapsed as well.
Question 2: In addition to that issue, I am also struggling with the Selection. When I make a select for Provider, Service Group etc. everything is still left in place. I know this is due to the Alternate State in place for the National Benchmark: %-To-Total. Is there any method that can be used so it only show what is being selected. Hopefully, that makes sense.