Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have a pivot table which consist of the dimension in the rows and the measures in the columns similar to this,
Sales Profit Loss
Customer A 10 5 2
Customer B 15 10 3
We would want this to appear as below, the measures should appear as rows and the dimension country should appear in the columns list.
Customer A Customer B
Sales 10 15
Profit 5 10
Loss 2 3
Thanks,
Venu
I was able to do this by dragging the country dimension and with blue arrow was able to swap the columns and the rows.