Hiding Column in Pivot Table

[#1]

Hi All,

Please find the below data

id	Type	name	salary	sales
1	A	AAA	100	1000
2	A	AAA	200	2000
3	B	BBB	300	3000
4	B	CCC	300	4000
5	C	DDD	355	5000
6	D	EEE	400	60000

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

Type	name	sum(salary)	sum(sales)
		300	3000
A	AAA	100	1000
A	AAA	200	2000

Thanks in advance

[sunny_talwar · Accepted solution]

May be using Dual() function

[#3]

Thanks Sunny