Hi,
I have two visuals in a sheet. Both are based on same dataset.
First visual is a pivot table with 3 dimension fields and has several measure/value fields.
Second visual is a regular table that shows the data in tabular format.
When I click on a number on the pivot visual, I want the data in the table visual to be filtered.
I set up a Filter Action on the pivot visual. But it is passing only the dimension field values as filters to the table visual. I need the ability to filter the table visual data based on what value/measure is clicked.
Example:
When I click on any value, only D1Value, D2Value1, D3Value are being passed to the table visual. I need Value1 or Value2 also passed, these are custom calculated fields. Is it possible? If not, please let me know if a feature enhancement request is already raised.
Thanks for your help.