Subtraction the column in a visual

Question

I have the following table (1) showing my expenses against each vendor. Now I have created a table in Power BI showing this (2) by putting "Cost Centers" in rows, "Vendor Name" in Columns and "Invoice" in Values. Now I want to know potential savings (negotaition) opportunity with the vendors by knowing the leader in price (lowest cost vendor) to us. Can you please help me how can I get the result which is in (3). I will appreciate the help. Thanks

(1)

Vendor NameCost CentersInvoice

Toli X	A	21
Voice	B	11
Scoot	C	56
Scoot	A	18
Scoot	B	16
Voice	A	21
Toli X	B	48
Scoot	A	56
Toli X	C	89
Voice	B	74
Actto	B	70
Actto	C	58
Actto	A	49
Toli X	B	86
Voice	C	63

(2)

	Toli X	Voice	Scoot	Actto
Cost Centers	244	169	146	177

(3)

					Difference from Leader
	Toli X	Voice	Scoot	Actto	Toli X	Voice	Scoot	Actto
Cost Centers	244	169	146	177	98	23	0	31

amitchandak · Answer

narangsumit0 , Not very clear, can you explain it. Also, I do not see any cost element

narangsumit0 · Answer

Cost element is cost center (A,B,C) which is the second header to table 1. I created a table visual in power BI using my own table. Now I want to create one more column in the same visual which will take the minium of three vendor cost center and subtract with each customer cost center to show an opportunity for savings.&nbsp;