Which format input table to use to make dashboard

[Morte1974]

All,

I am developing a sales dashboard based on a self developed sales forecasting excel sheet.
However this sales forecasting excel sheet if mainly horizontal and not vertical.

In the attached excel sheet I have developed to tables:

1. Input Table version 1 This is the orginally format of my sales forecasting excel sheet, but I can't develop a solid dashboard from it as the certain quarter there is the revenue amount in there.

I thereofore think I have to manually adjust it to the Input table version 2.

I would like to here your opinions?

Thanks in advance.

Best regards,

Maarten

[Keebellah]

Hi Maarten, I haven't looked at your file but have you tried adding a pivot table that only shows the data you need for your dashboard?