Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have below data
Emp | Country | Region | Month | Sales |
Ram | India | APAC | Jan | 200 |
Raj | UK | Europe | Jan | 100 |
Ram | India | APAC | Feb | 300 |
Created a pivot table as below
APAC | ||
Emp | Jan | Feb |
Ram | 200 | 300 |
When clicking on APAC then need to show country values (dynamically) in same table
APAC | India | |||
Emp | Jan | Feb | Jan | Feb |
Ram | 200 | 300 | 200 | 300 |
Thanks In advance,
Priya
Please select Correct Answer and close the thread.