3 Replies Latest reply on Jun 25, 2018 7:55 AM by garth.conrad

    Comparing two different hierarchy data in row fields

    Aravinda Kumar

      How can I create a calculated field to compare data in the row fields with a different hierarchy level, sample below.

      Basically, I have two data sets, Spends is Spend type and Sales is by Total.

       

      Spend TypeCategoryData TypeSpend ValueSales Value
      ATLHair OilsSpends100
      BTLShampoosSpends50
      ATLHair OilsSpends40
      BTLShampoosSpends75
      Hair OilsSales120
      ShampoosSales90