Why cant we calculate percentage per row in pivot table?

I tried to count the percentage per max in each row of pivot table but not possible, there is only percentage from the max in the whole pivot table

I tried a solution from the community, it works ok on the higher granularity, but not working properly with filters.

0 2 425
2 REPLIES 2

Try using a calculated field that divides each value by the max in that row. Add it as a percentage column, so it calculates by row context. If filters still disrupt it, ensure they apply after the calculation. Hope it helps

@jeffreywolfe how to get the max per row in the calculation I never saw a function like that 
can you please help