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]



      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?