formula help lookup

[scarp]

Hi all, i need some help with creating a dashboard of results and i don't know how to do it.

Basically, i have a input of data sheet that looks like this, only more data:

The YTD Savings is based on a sumif statement adding each month past. Data sheet
		YTD Savings
Supplier	Plan	$$
supplier 1	Actual	$$
supplier 1	Increases	$$
supplier 2	Plan	$$
supplier 2	Actual	$$
supplier 2	Increases	$$
supplier 3	Plan	$$
supplier 3	Actual	$$
supplier 3	Increases	$$

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

I want to create a dashboard that contains this data in a more readable format for quick review and then add a chart for visual reference.
Similar to below, but i don't know how to do lookups from multiple datapoints.

Am i over thinking this task. Can anybody help?

 

[oldbrewer]

below is not there so it is hard to see what you want

we could rank by actuals or increases ??