Pivoting in Adhoc report

[#1]

Hi All,

I'm trying to do pivoting in Adhoc report I created but unfortunately can not put the dimension on top of chart !

Does anybody know where the problem is with the Adhoc?

Thanks,

[Anonymous]

Check that Allow pivoting is set on Presentation tab.

Pivoting is a little tricky with a mouse. Are blue lines appearing when you grab the dimension label ?

Jonathan

[#3]

Thanks , but it is not the case. I'm able to move the dimensions back and forth but not able to put it on the top !!!!

[Anonymous]

Are you sure it is a pivot table and not a straight table ?

Jonathan

[#5 · Accepted solution]

Yes.

I found the problem.

If you have many Dimension and expression for some reason it does not work or at least in my case

I tried to reduce the dimensions and do the pivot and then add the dimensions then it worked.

Thanks for the reply.

Nima

[#6]

Hi Nima ,

Can you please explain how it was achieved?