Pivot table - Show values as % of row

[Anonymous]

Hi all,

I would like to show the values in the column '% Re Reviewed' as % of row.

For example the first row: 82/(82+5)=94.25% and 5/(82+5)=5.75%

How do I do it?

[sunny_talwar · Accepted solution]

Try this expression

Count([Task Name])/Count(TOTAL <Region, Country_Cluster> [Task Name])

Assuming your Count of Task Name expression is this

Count([Task Name])

[Anonymous]

It works!

Just changed the [Task Name] to [Task_Name]

Thanks a lot!