1 Reply Latest reply: May 23, 2018 2:46 PM by Ivan Bozov RSS

    Need If statement to calculate based on dimension to the left

    Dan Coen

      Hi,

       

      I have a table that I need to calculate based on the dimension on the left of the table. The two dimensions are from an inline load I am doing called "Grouping". Below is the table:

       

      5-23-2018 2-29-15 PM.jpg

       

       

      I need the measuers for Orders(000), Sales(000) and PTQ calculate based on the dimension being MTD or Prior Day. Below is the analyisis I was using.

       

      if(Grouping='MTD',

      Sum({<

      [Fiscal - Flag Current Date]='Y'

      >}

      [Amount - Ordered USD])

      ,

      Sum({<

      [Fiscal - Flag Current PTD]='Y'

      >}

      [Amount - Ordered USD]))

       

      However, this is just returning zeros. How can I get this measure to identify and consider the dimension in the corresponding column?

       

      Thanks!