1 Reply Latest reply: Mar 10, 2015 3:48 PM by Gysbert Wassenaar RSS

    Cyclical Group

    Jon Maginess

      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

        • Re: Cyclical Group
          Gysbert Wassenaar

          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).