interactive sort

[adiarnon]

hi i have this table,

its a pivot table

my user want to be able to sort the table by interactive sort.

do i have another solution then to make a streight table and to define each column by set analysis with his own month?

thx,

adi

[adamdavi3s]

I've had a similar issue before and you can write a macro and use a clear textbox as a 'button' to call the macro to sort the table.

Not ideal but it does work depending how you want to do the sorting.

[adiarnon]

tnx,

we are working with the IE Plugin

we tried to work with macro but its not working good

any other options?

[settu_periasamy]

Hi,

May be look this Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)

[antoniotiman]

Hi Adi,

You can use in Sort an expression like this

Sum({<Month={$(=vSort)}>} Value)

vSort is variable in InputBox

See attachment

Regards,

Antonio