Calculate percentage of each category based on total

[Anonymous]

Hi All,

Please have a look at the below table,

I wanted to calculate % for each category and for the below filtered category ABC, I wanted to calculate the percentage of category total. For example, (2/4)*100 gives 50% for column X=XXX and location = ABC with a count of 65. Similarly for each category.

What I don't want is the percentage of grandtotal. i.e (2/11)*100 = 18%

[adityavighne · Accepted solution]

@Anonymous 

add same column Y next to it and take a percentage of total instead of count -

[Anonymous]

Thank you it worked

---

@adityavighne wrote:

@Anonymous 

add same column Y next to it and take a percentage of total instead of count -

---