% of column total in Looker Studio

[kdimitrof]

Hi folks,

Do you know if this feature would be added at some point as it is impossible to have ratios based on column total. I tried some workarounds but they are not giving me the desired output.

I have submitted feedback, and hope many of you experienced the same.

Kind regards,
Krassi

[ArkadyZagdan]

@kdimitrof 
A  work around is Custom query from BigQUery as data source with precomputed % for anything you need.
Cons are costs related to excessive usage of the table.

[kdimitrof]

Thank you, we are doing this for some properties, however it would be great to have it without the need to modify the underlying data.

[Beginner]

Hi,

Maybe you have tried this already but this worked for my purposes.

How to create a percentage of column pivot table in Looker

Hope this helps

[kdimitrof]

Thank you, but I wished to be as simple as in Excel 🙂