Is there a way to make bar in the chart after clicking on it to turn into table that will show the values that make up this bar?
For example i have a chart where i show what products show what return. I have 15 products in a bar "0-50%". After i click on this bar i want a table to be displayed that would show what products are in this bar.
You could make a drill down dimension by going to the dimension tab and clicking "Edit Groups." Create a "Drill Down" group, which includes the 0%-50% bar you refer to above as well as the field for product name. Make sure the 0%-50% field is first in the list; you can add custom labels to the fields here. Now just add the drill down dimension as the dimension in the chart, and when you click on the "0%-50%" bar, it will drill down into the products that make up that bar. Assuming you are summing by a "total spend/revenue" type field, this should work.
If you really want to show the data as a table, allow "Fast Type Change" from the general tab. Simply check Straight table and bar chart and you'll have the option to switch the chart format in the top right corner (next to minimize and maximize).
another way is to use field event trigger to show a hidden table. this helps if the table has completely different dimensions and expressions. you can decide which way works better for you.
for field event trigger, go to document properties > Triggers > Field Event Triggers > select the field (i'm assuming Products here) > Add Action for OnSelect > add an action type for Layout to activate object > input Object ID for the table.
