Looker Studio: how to retrieve difference percentage value of column1 from maximum value of column2

[Alegrune]

Hi I have these values:

Product | Sales | Price
A                1500     10
B                5000    15
C                 250       25
D                 1700     30

Leader sales product price is 15

Want to get 
Product | Sales | Price | Price Diff
A                1500     10        -33%
B                5000    15         0%
C                 250       25       67%
D                 1700     30       100%

How do i achieve this in looker studio using all my dimensions values? Thank you!

[Alegrune]

Anyone? Thanks!

[EdgarA]

Hey there! I don't think what you want to do is possible as the max is based on a different dimension, but there's a more manual workaround. You could create a parameter (https://support.google.com/looker-studio/answer/9002005?hl=en#zippy=%2Cin-this-article) for "Price of product with most sales" and add a control to the report canvas so you can type in the price manually for the product with the most sales.

Then, create a calculated field (https://support.google.com/looker-studio/answer/6299685?hl=en#zippy=%2Cin-this-article) that uses this parameter and add it to the table. For example:

(price - <parameter>) / <parameter> 

You can set the result as data type "Percent". 

I hope this helps!