6 Replies Latest reply on Feb 26, 2013 11:02 AM by hub.yoo

    is it possible to create a calculated field that shows multiple dimensions

    hub.yoo

      Hello,

       

      I had a quick question, is it possible to create a calculated field that outputs two dimensions/measures? If so, what is the correct syntax for this type of calculation.

      Specifically, something like the following:

      rep2atonce.JPG

      which should be the equivalent of this:

      manual rep.JPG

       

      To further elaborate:

      I've been using parameters to swap measures and/or dimensions using the following:

           CASE [Parameters].[Something sexy:]

           When 'peaches'' THEN [Number of Peaches]

           WHEN 'beyonce' THEN [drool]

           END

      Is it possible to have something like

           CASE [Parameters].[Something sexy:]

           When 'peaches'' THEN [Calendar] ; [Number of Peaches] ***

           WHEN 'beyonce' THEN [drool]

           END

       

      ***I would like it to emulate having both [calendar] AND [Number of peaches] on the columns shelf.