Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a cyclical group set up which is used accross different tabs of my report.
There are several fields in this group, however for certain objects I want to exclude one.
Is it possible to say have a master group of say 10 dimensions then dynamically exlude individual dimensions on different graphs rather than say setting up 10 different cyclical groups?
Thanks
You will need 10 different groups if you wish to use groups.
Perhaps an easier solution is to use a table with field names and use that to select the dimension for the chart(s). See this blog post: Customizable Straight Table. A listbox using such a table with field names can be easily modified to exclude a specific value using an expression like =if(MyField <> 'ExcludedValueHere',MyField).