Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a bar chart with dimension as 'Month' and 'Sum(Sales)' as expression. Now I need to change Dimension in this chart by clicking list of dimensions available. e.g. If I click 'Year', Chart will give sum(sales) w.r.t year...likewise need to chnage for other dimensions one ata time.
Please let me know is there any macro to do so.
Thanks,
Sunil
You need per example...a year, month or day?
You need to create a group of dimensions, e put the group in dimensions....
after that, just click in the bar to change the dimension...
Hi,
Why do you use the cyclic or drill down group for that by the help of this when you create a cyclic group which ever dimensions you define in that group it works for that suppose you create Year-Quarter-Month-Week-Day all this dimensions. Than it will change by cyclic order of the orders.
Regards,
Anand