2 Replies Latest reply: Nov 13, 2009 2:39 PM by kajok RSS

    Reg: Expression cyclic group in Pivot table / St table :

       

      Dear all

      In Chart Properties under Expressions tabs there is an option for greating cyclic group for expressions.

      Im using a Group which has three expressions reg.

      1.Profit

      2.Cost

      3.Revenue

       

      as labels.

      but i want to use only 2 labels(members) like

      1.Profit

      2.Cost/Revenue

      in cyclic.

       

      If we click Profit in cyclic only profit exp should come.

      If we click Cost/Revenue in clyclic two expressions for Cost and Revenue should come.

      can any one tell me how to use cyclic here.

       

      Regards

      Ashok Kumar

       

       

       

       



        • Reg: Expression cyclic group in Pivot table / St table :
          Oleg Troyansky

          Ashok,

          Cyclic groups only allow single expressions (very much like cyclic dimension groups only allow single dimensions). It looks like in your case you need two similar charts, one with a single expression and another one with two expressions.

          hope it helps,

          Oleg

          • Reg: Expression cyclic group in Pivot table / St table :

            I ran into the same problem.

            My solution was to use an if expression based on a variable in the title, label and expression entries.
            Also I used a button to switch the status of the variable (here it is named my_cyclic) between wanted states.

            For instance:

            The button action used is set to change the variable my_cyclic as follows: (so my_cyclic is always either 0 or 1)


            =mod(my_cyclic+1,2) // my_cyclic swaps between 2 expressions, increase the number 2 to increase the size of your cyclic group.


            Expression:


            =if(
            my_cyclic=0, sum(field1),
            if(my_cyclic=1, sum(field2_a*field2_b))
            )


            title:


            =if(my_cyclic=0,'Title 1',
            if(my_cyclic=1,'Title 2')
            )
            &' using the my_cyclic variable '