How to calculate the Month wise Percentage

[Ther_Rider]

Category	Oct-2022	Nov-2022	Dec-2022	Jan-2023
A	1848	1496	1765	1663
B	99	8	11	6
C	1	3		1
D	289	199	212	217
Grand Total	2237	1706	1988	1887
Help me to understand How to calculate percentage as below
Category	Oct-2022	Nov-2022	Dec-2022	Jan-2023
A	83%	88%	89%	88%
B	4%	0%	1%	0%
C	0%	0%	0%	0%
D	13%	12%	11%	11%
Grand Total	100%	100%	100%	100%

[sidhiq91]

@Ther_Rider  You can use the below expression as follow to calculate the Percentage

Sum([Oct-2022])/ Sum(Total [Oct-2022])

If this resolves your issue, please like and accept it as a solution.

[Ther_Rider]

Dear sidhiq91,

Thnx for reply, actually I want to do it in pivot against each month

[Ther_Rider]

Dear Siddhiq91,

Thnx for reply, actually I want to do it in pivot against each month,

Please find the attached data sheet for your reference

[Anil_Babu_Samineni]

Hello,

Perhaps this?

Sum(Aggr((Sum(Sr_number)/Sum(TOTAL Sr_number)), Category))

and format like this.

[Ahidhar · Accepted solution]

try this 

sum(measure)/sum(total<monthfieldname>measure)

and then change formatting to 12%

it will show this

[Ther_Rider]

Dear Ahidhar,

Thanx a ton, its working

[Ahidhar]

Glad to Know