7 Replies Latest reply on Nov 27, 2016 5:58 AM by JayC

    Mixing aggregate and non-aggregate measures in CASE statement - Help Needed Plz

    JayC

      Hi All,

      I am stuck in mixing Agg & Non Agg measures. Have tried solutions from few threads with no success before posting as a question here.
      Please help me in resolving.
      Have attached mock up version.

       

      Issue arises when i try to use PPT in the case stmt.

      PPT is aggregated already.