Author Topic: Percent of total  (Read 287 times)

pbassey

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 36
    • View Profile
Percent of total
« on: November 30, 2022, 04:48:54 am »
The summary function offers the ability to generate the following aggregate functions (avg, count, min, max and/or sum).  Is there a way to generate the percent of total?

Attached is an example of what I would like to do...

Thanks in advance for your help.

-P

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6309
    • View Profile
Re: Percent of total
« Reply #1 on: November 30, 2022, 04:29:10 pm »
Excel formula (=f2/f5 and so on) can be used and format of the column set to "#.00%"