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.
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
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |