Show values as % of parent row total in Google Looker Studio pivot as Microsoft Excel pivot

[marcosacco]

Is there a way to display data in a Looker Studio pivot table as a percentage of the parent row total, like in Excel's 'Value field settings' -> 'Show values as' -> '% of parent row total'?"

I've tried with calculated field, but the operator OVER doesn't work

[Lobo-Google]

HI @marcosacco, thanks for your post!

You can create metrics and select a comparison operation to see the percent total. The Add comparison metrics and running totals has detailed instructions, and also some helpful examples!

There's also a neat solution posted in the Community, if that is more helpful to your use case!

[marcosacco]

Thanks Lobo! I've tried as explained in support, but it doesn' work as I want in a pivot table report into Looker Studio. Here an example from Excel pivot. The same report isn't not easy in Looker Studio where is the % of hours (H% column) as % of the parent row (as can you easy check in Customer1 or Customer4).
[The hierarchy is Customer, Project, Task].
I've tried also with a calculated filed using OVER, like this
SUM([H]) OVER ([Customer], [Project], [Task])
but there's this error
Syntax error: Expected ")" but got "."
and OVER doesn't run
It's frustrating!

[Beginner]

Hi,

This article helped me achieve a % of parent row.

Hope this helps you too.

https://lucidgen.com/en/how-to-create-a-percentage-pivot-table-in-looker/

[marcosacco]

Thanks a lot. It's a good way!