Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems related to merging headers in pivot table

Hi Community,

CaptureA.JPG

I have followed the instruction from John in the previous discussion and it did work. However, I encounter another problem that there is a column without value appeared at the left side of the table. This column shows when I disabled 'Suppress Zero-Values' in the Presentation tab. I disable this because I would like to show the department with value in the table. How can I get rid of this column?


Previous Discussion:

Merge headers in pivot table


Maverick

2 Replies
settu_periasamy
Master III
Master III

Have you tried  'Suppress When value is Null' Option in Dimension Tab ?

Capture.JPG

Not applicable
Author

I have tried but it seems not working