Hi All,
I have a straight table having 5 dimensions and 5 expressions.
Each expression is a separate calculation.
Now when a user click on a value in a cell in first expression, i should be able to capture that the value selected is from the first expression .
Similarly for the rest of the expressions.
I want these because i want to show detailed reports based on that.
I cannot create an inline table of expression names and then create a cross pivot table because then sorting on the expressions will not be possible.
So how can we achieve this?
Regards,
Jatin Kolhe.