Pivot Table - unable to pivot dimension date

[Anonymous]

Hi All,

Need help with pivoting date column,tried number of times but unable to pivot date column.

please see attached docs(QVW and Screenshot).

Result should be same as screenshot attached and unable to hide column status with rgb values

[MK_QSL]

Go to Presentation tab

and tick allow pivoting

[#3 · Accepted solution]

Hi Nitha

As Manish said, you  need to check "allow pivoting" then you can drag and drop the dates to the top of the chart.

In order for status to be shown in the cells, the cell value expression should be the actual status and the cell colour expression needs to be the function that you have with RGB() in it.

See attached

Erica

[preminqlik]

hi PFA

[mangalsk]

Hello,

I have done as per your requirement

[Anonymous]

Tried with Ticked allow pivoting still unable to pivot

[Anonymous]

Hi Guys,

Thanks for all help,but i am not able to do pivoting
after ticking allow pivoting check box

[MK_QSL]

here we go...

[Anonymous]

Thanks guys for all help and able to pivot and successful.

All replies are correct
and unable to mark all correct and helpful.

Thanks

Nitha