2 Replies Latest reply on Sep 14, 2017 6:10 AM by Haya mohiyaddin

    group by an agg measure

    Haya mohiyaddin

      Hi All,

       

      I am building a dashboard as below. I have a view by parameter which aggr the PYCOGS ,PY PQ COGS  etc

       

       

      PYCOGS = SUM([CQ_forecast_Units])* ([PY_LQ_UnitCogs])

       

      I want to see sum(PYCOGS) when changed the view by parameter to PF/PL/Category etc .As of now I get it by multiplying the aggregate units by aggregate CQ_forecast_Units and PY_LQ_UnitCogs

       

       

      Can somebody please help me on this.

       

      Regards,

      Haya