Looker Studio Pivot Table Calculations Not Working

[googlenoob62]

I'm using Looker Studio and needing to build a report that shows the Users, The status of their projects, The count of each status for the User and the % of the status for the user.

I have the following data:

User	Status
John Doe	Declined
Jane Doe	In Progress
Jane Doe	In Progress
Jane Doe	In Progress
Jane Doe	In Progress
Jane Doe	Not Started
Jane Doe	Not Started
Jane Doe	Not Started
Jane Doe	Not Started
Jane Doe	Not Started
Jane Doe	Not Started
Jane Doe	Not Started
Jane Doe	Not Started
Jane Doe	Not Started
Jane Doe	Not Started
Jane Doe	Completed
Jane Doe	Completed
Jane Doe	Completed
Jane Doe	Completed
John Doe	Initiated
John Doe	In Progress
John Doe	Initiated
John Doe	Initiated
John Doe	In Progress
John Doe	Initiated
John Doe	In Progress

I need to create a report like this but running into issues in how to properly build the formula or getting this to work in the Looker Studio Pivot Table:

User	Status	Count of Status	Percent of Status
Jane Doe	Completed	4	22%
Jane Doe	In Progress	4	22%
Jane Doe	Not Started	10	56%
John Doe	Declined	1	13%
John Doe	In Progress	3	38%
John Doe	Initiated	4	50%

[sam8]

I see. It looks like you're trying to get the percents as subtotals. That is, all of Jane Doe's rows should add up to 100%, but the total of all the rows will be 100% times the number of users. I don't think that's possible to build with formulas in Looker Studio. I think that logic would need to be defined in your data source.