0 Replies Latest reply: Oct 15, 2018 10:51 PM by Chandni Popat RSS

    Need to subtract Curr Sales and Prev Sales in data model.

    Chandni Popat

      I have

      StatePeriodSale
      MPCurr100
      MPPrev200
      UPCurr150

      UP

      Prev250
      CGCurr300
      CGPrev200

       

      Need to show only those State where Curr  Sales - Prev Sales is greater or equals to 100.

       

      I have to do all these in Data Model only. Please suggest a way to do this. There is a simple way to convert the values of Period column into different column and then subtract the values. But I am not that good with Generic load. So if there is any way to convert column into rows then please suggest.