Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Was there a solution for this issue? Am trying to do somethign similar but not able to get anywhere.