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

Hiding Column in Pivot Table

Hi All,

Please find the below data

  

id Typename salarysales
1AAAA1001000
2AAAA2002000
3BBBB3003000
4BCCC3004000
5CDDD3555000
6DEEE40060000

Without using macro i need output like below in Pivot Chart .I want to hide dimension Id.

 

Typenamesum(salary)sum(sales)
3003000
AAAA1001000
AAAA2002000

Thanks in advance

1 Solution

Accepted Solutions
sunny_talwar

May be using Dual() function

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

May be using Dual() function

Capture.PNG

Not applicable
Author

Thanks Sunny