5 Replies Latest reply on Jul 22, 2018 8:30 AM by Aravinda Kumar

    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