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.