Order pivot table

[Anonymous]

Hi,

My english is very bad, but I will try to explain my problem. I have a pivot table with 3 dimensions. The first dimension is a cyclic group.

I have 6 expresion in my pivot table. I would like order my pivot tablet by expresion as in a simple table. Can I push in a column and to order by this column?

Thanks

[vikasmahajan]

In Pivot Table you order as you desired click on column and drag where you want to kept.

Hope this help you

Vikas

[#3]

Pls share us the sample app so that we can share better

[Anonymous]

Hi,

In Simple table, if is possible order doing click on column, but in pivot table if I do click on column... I don't get to order. It doesn't nothing

I don't want drag the columns.  I would like similar performance of a simple table but in a pivot table

I add capture image

Thanks

[#5]

Hi,

Could you use Straight table instead of pivot table.

And in properties -> sort -> select the interactive sort option then double click on the dimension where you want the order/sort.

hope i my solution suits the requirement.

[#6]

You can use expression in sort tab. see image

[vishsaggi]

Did you try sort by Y-value. Can you share a sample app to look into?

[Anil_Babu_Samineni]

Better, It may possible. But atleast share sample data