Calculate Percentage for use in Scorecard

[Beginner]

I have Looker Studio connected to data stored in google sheets.

The data concerns Actual Turnover and Budgeted Turnover over several years and is stored in a format similar to this sample (with random figures).

https://docs.google.com/spreadsheets/d/1Nmh7ATrBrIazkALPkI09uGpE3KqQVKCSezbnBi5_gXc/edit?usp=sharing

I would like to create a Scorecard and using a calculated field, show what pecentage of the budgeted Turnover the actual turnover is. I read somewhere that I would have to change how the source data is laid out and have the actual and budgeted turnovers in separate columns but is this the case? If possible,  would like to avoid having to change the structure of the source google sheet.

Thanks!

[ArkadyZagdan]

@Beginner 
You nened to have actual values and turnnover values in same row andd different columns
As you nneed to computer two metrics (actual and Budget) on a dimensions basis (FY).
There is no othher way around thhis.

Hope it helps
Arkady Zagdan

[shijithpulikkal · Accepted solution]

Hi,

you can achieve through Data Blending.

you can refer this Lookerstudio report with edit permission using your sample data https://lookerstudio.google.com/reporting/fb15e7bb-0408-4337-87c2-5196e760f5e6

Shijith Pulikkal - Xtract Studio

[Beginner]

This is exactly what I was hoping for. Thanks for the explanation and increasing my knowledge!!