Calculate the % for a Row in a Table Where the Values are Strings

I'm trying to get a report in Looker Studio in a table where it is showing me the percentage of the different Status for a region. The items in the Status field are strings.

When I use a normal pivot table I get the following which looks to be doing the calculation on the whole table instead of just a region:

2024-03-06 13_24_00-Book1 - Excel.png

 2024-03-06 13_26_13-HW Ops Reporting › Health Motions - Endpoint.png

 

2024-03-06 13_26_25-HW Ops Reporting › Health Motions - Endpoint.png

 

If I filter to just one region I get the following data which is the correct calculation I'm looking for but I need it to do this for all regions:

2024-03-06 13_25_13-Book1 - Excel.png

 

 

 

 

 

0 0 187
0 REPLIES 0
Top Labels in this Space