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
Bookmarks