Is drill through (to source columns, not rows) possible?
Hi
I know drill-down to row-level information is possible. However, I would often like my users to be able to drill through to source columns. For example, I plot only the Gross Margin column along Y-axis which is derived from Sales and Cost columns. Let's say for the year 20xx, profit is 100K and only when users click on this do they need to be shown Sales and Cost for the same year at the same aggregated-level. In this example, it would be just two numbers, let's say 250K and 150K, respectively.
Is this possible?
Thanks,