2 Replies Latest reply on Apr 20, 2019 1:05 PM by Dan Gomes

    Calculate Percent based on Row

    Dan Gomes

      Hi Guys,

       

      In simple words, I have a report that has two rows with date in colums. The first row are Offers made to customers in that period, the second row is the number of customers that purchased the offer.

      I want to include a third row to show ratio of Purchase/Offer in percent. Show all three rows.

       

      See matrix and sample twbx attached. Thanks in advance.

       

       

       

        

      TypeJan-19Feb-19Mar-19Apr-19
      Offer9,16610,69319,9784,384
      Purchase3,8944,2976,3231,369
      % Purchased42.5%40.2%31.6%31.2%