Drill Down associate data based on selected/clicked expression in Pivot chart
Dear Community Members,
I have created a Pivot Chart with one dimension "Business Unit" along with multiple expressions. My requirement is that if i click in a cell
for a particular business unit and an expression. I would like to display the associated raw records in another tabular report. I have attached the screenshot of the chart for better understanding.
Example) If Business Unit is "RCTG" and expression is "Net Add(QTD)" the value is -4. So, if i select/click on -4 then I need to display the data for these 4 records. The solution should be flexible and i can change the business unit and expression as well. Please let me know the approach to solve this problem.
