Hi,
In this pivot table report, I would like to show the data with standardized column format such as:
Reporting Quarter Reporting Period Site CCM targets total encounters.
However, in the pivot table report in the attached file, I couldn't get the "total encounters" column to display actual total number of encounters because it is using the same CCM target filter, which is set to = "yes".
That is why CCM targets column show exactly the same value as the total encounters column, which is NOT desirable.
So my question is....is it possible to do what I need to do using pivot table? or is there any other way to do it that I'm not aware of?
Could anybody point me in the right direction please?
Thank you
Bookmarks