4 Replies Latest reply on Oct 19, 2016 1:00 PM by Raj Kumar

    Creating a calculated field

    Raj Kumar

      There is a dimension Project, it has values Planned, In Progress. There is a measure Resources. I want to showcase the sum of resources twice in Columns. One will have resources both Planned and In Progress, other should have only Planned. How to filter on Resources measure in the second value in the columns shelf.  I tried this.

       

      Placed Sum(Resources) in columns shelf, then created one calculate field "New" which says

      If [Project] = "Planned" then SUM([Resources])

      end

       

      Placed both SUM(Resources) and AGG(New) in columns shelf, but this is providing me expected result.

       

      Any suggestions.

       

      Thanks

      Raj