8 Replies Latest reply on Dec 17, 2019 12:42 AM by Donna Coles

    calculating percentages on subtotals

    harishkumar kummara

      Hi,

       

      I have four columns- category,sub-category,id and date.

      category has four countries, sub-category has success, fail,marking,pending ,distinct id's in id columns and date column.

      I would be needing a text table displaying

      hours,country wise success percentage over other three sub-categories in the COUNTRY LEVEL.

       

       

      country-1country-2country-3country-4
      hoursfailsuccessfailsuccessfailsuccessfailsuccess
      12%98%2%98%2%98%2%98%
      22%98%2%98%2%98%2%98%
      32%98%2%98%2%98%2%98%
      42%98%2%98%2%98%2%98%

       

      Please help

      Thanks