1 Reply Latest reply: Oct 14, 2016 1:00 PM by Sunny Talwar RSS

    I am trying to calculate % based on subtotals in pivot table in Qliksense

    vineeta dahiya

        In pivot table I will have Country , State  Line Amt. I need to show the % using subtotal values in qliksense

       

      CountryStateLine Amt%

      India

      Delhi3030% (  (30/100)*100
      Punjab4040%
      Haryana3030%
      USLA2525%
      CA2525%
      New York5050%
      Total200--

       

      I am looking something similar to  Line Amt / Sum(Line Amt) Group By Country.