Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I've got a pivot table with 1 dimension ( month/date ) and 3 expressions ( actual, forecast, and variance ). Right now it shows the month/date in the left collumn with the 3 expression values to the right of it. Can I make the month/date go accross the top with the 3 expression value beneath each date? Thanks, Jim
You should be able to just drag and drop the month/date to the top if you have it set as a pivot table.
You should be able to just drag and drop the month/date to the top if you have it set as a pivot table.
Yes you can, just drag the dimension to the top of the pivot table.
Here is an example:
Hope this help you. Regards.-
Guys, thanks for your help! thought I tried that but now it works.