How to show the details when click on the measure in the pivot table
Hi All, I use one pivot table to show some figures, and all of the figures are created by expression and including the set analysis.
For example:
Year, Month, the count of the orders whose prices are more than $10
2011,1, 300
2011,2,400
And I put the detail OrderId and Price into the table object.
What I want is, When I click the value of the pivot table, the table can show the orders list that is related to the pivot. In this situation, all of the orders whose prices should be more than $10.
