Pivot table report, one column NOT showing the total

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

Hi,
See the result of what I undersand in the attached file
Best regards

Originally Posted by jpr73

Hi,
See the result of what I undersand in the attached file
Best regards

Hi, thank you. Few questions though:

When you filter on "yes" or "no" field, the last column disappears.

Also, if you try to hide the "No" column, the quarterly report filter disappears also.

There are also empty cells in the pivot table.

We simply just want to have 5-column report showing:

reporting quarter reporting period site ccm targets total encounters

Are these all formatting issues? Or I am asking too much that pivot table cannot do? I am also reattaching the file.

Thank you