2 Replies Latest reply on Feb 9, 2016 9:14 PM by Rajeev Pandey

    Hardcode measure value

    arthi.keat

      Hi,

       

      I would like hardcode measure values for certain dimensions. For example in the attached workbook, I want to create measure called as "Targets" that has values for Segment.

       

      If([Segment]="Consumer") Then 560

      ElseIf ([Segment]="Corporate") Then 460

      ElseIf ([Segment]="Home Office") Then 360

      ELSE null

      END

       

      But I am not able to get it to work. I know we can get it by having a secondary data source but any ideas on how we can do it in a single data source.

       

      Thanks,

      Arthi.

        • 1. Re: Hardcode measure value
          Tina Hauser

          Hi Arthi!

           

          What specifically wasn't working for you? I opened your workbook and created a field using your formula (Calculation1). Then placed it on the worksheet as an attribute.

          Is the attached what you are looking for? If not please let me know and I will continue to assist.

           

          Tina

          1 of 1 people found this helpful
          • 2. Re: Hardcode measure value
            Rajeev Pandey

            Dear Keat,

            you can solve your issue in two way.

             

            1) Approach 1: Drag the calculated Field into the row shelf and then right click on Arrow sign and select attribute.

             

             

            2) Approach 2:Uncheck the Aggreegate measure (Analysis->aggregate mesaure)

            Please let me know if you need any more information on the same.Please mark the answer as correct if it solves yoru problem.This will help other members when they are searching for solutions to similar problems.