Dynamic Spotfire KPI Formula Based on Selected Master KPI
I have a master KPI chart that has a detail KPI chart listening to it. The master KPI chart can have two measures (for simplicity): Eng Displ and Cylinders. The detail KPI chart then responds when the Eng Displ KPI is selected to show Cylinders broken down by business area:
I now want the detail KPI chart to break down Cylinders if it is selected without creating another details visualization (I want it all in the same visualization).
Summary: I want a details visualization to change formulas depending on which part of a master visualization is selected.