Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be using Dual() function
May be using Dual() function
Thanks Sunny