Hello!



I have a question about a pivot evaluation.

First of all, I apologise if the texts in the screenshots are in German.



We receive completed bills of quantities with prices from suppliers.

I now read these in using Power Query and compare them using a pivot table.

It works very well so far.

We used to do this manually, which was very tedious. Power Query makes the whole thing much easier

Pivot-Tabelle.jpg

Now to my actual problem:



Is there a way to determine the smallest value of a row in a pivot table and then display the deviations from each other as a percentage?

In the past, we have always done this using a formula like this

Auswertung_vormals.jpg

So you can see who was the cheapest (green +%), or who was more expensive than the cheapest supplier (red +xxx%) in this position by how many percentages.

Thanks a lot

Best regards from Linz / Austria

Simon