Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am having table data as follows
Customer | Amt |
a | 8 |
a | 10 |
b | 20 |
c | 7 |
d | 10 |
e | 15 |
f | 12 |
f | 20 |
I Want to Display Data in Pivot Table as Top 3 Customer Names and rest of the customers total as Label Others as shown below
Customer | Amt |
f | 32 |
b | 20 |
a | 18 |
Others | 32 |
Total | 102 |
Please Help me in resolving the above.
Thanks in Advance.
Chandu
hi,
I hope attach application helps.
Deepak
Thanks A lot