Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm sorry, this is probably a very easy question but I can't get my head around it. I think it might be solved by groups, but I'm not sure.
I want to create a bar chart, in my example, I've chosen 'favorite foods'. I'd like it so that it was a simple bar chart showing the three groups of food (ice cream, biscuits, cake) (as in graph 2), and then when the user clicked on the group, all the varities of that groupwere arrayed (graph 3). I can't get it to do this and I'm sure it must be possible!
Any help much appreciated!
Hi,
If by cyclic order / Drill Down if you use to create a table it looks good and the requirement that you want to achieve is display corretly.
See the sample file
Rgds
Anand
Make a drill down group with first field Food Group, and second field Food Type, and use that as your dimension.
Take a look at tha attached which includes a screenshot of the set-up of the drill-down group.
Hi,
See the attached samle it will diaplay both Cyclic or Drill down group.
See the solution sheet.
HTH
Rgds
Anand