Can we somehow provide actions in Pivot table on expressions?
Hi
I have a pivot table , there are around 15-20 expressions in it . It's more of a summary table .I want if i could click on the headings of expressions then it should filter the corresponding data. Is it possible?.
1.The dirty way is to use transparent action buttons on headings(Fix the position of table, so it doesn't move).
2.The other way can be to use them as dimensions rather than expressions. But that too is a very lengthy task.
For the time being i am providing few details in this pivot table and asked my users to see the summary in the collapsed data and detailed view in expanded table .But neither me nor my users are totally satisfied.
I really don't want to do it by 1st method as i feel it involves more maintenance in the long run.Any suggestions on alternate way of doing this would be appreciated .
