4 Replies Latest reply on Jun 26, 2012 10:11 AM by Vito De Filippis

    Can I use grouped dimensions in calculated fields?

    Vito De Filippis

      Hey guys,

       

      I'm trying to create a parameter paired with a calculated fields that will allow me to swap measures to analyze a view by. This way I can look at sales by segment, and then sales by region, without switching the view. I got it to work using a list parameter and the following calculation:

       

      If [Parameters].[Segment] = 1 then [Region]

      Elseif [Parameters].[Segment] = 2 Then [Location]

      Elseif [Parameters].[Segment] = 3 Then [Segment]

      End

       

      The problem is that the 'Region' is a grouped dimension so it doesn't appear on the 'Fields' section of the calculated field window.

       

      Is there any way around this?

       

      Vito