PowerPivot - Incentive Programming Usage

[RO24]

Morning All,

I am getting my first exposure to Power Pivot and all of its uses. One of my goals is to create a dashboard for all the incentive programs that we have within our Company. I'm not sure what the capabilities are here to explain to me the best route to this, but I have created a Dashboard that looks more like a summary sheet than a nicely formatted and "cool" looking dashboard.

Can anyone help me with this creation? Also, say we have 15 separate incentive programs with 10 vendors for our sales team. Is there a way that I can display each of these Dashboard within one Power Pivot file and be able to automatically update each month?

Thanks in advance.

RO

[:) Sixthsense :)]

Is there a way that I can display each of these Dashboard within one Power Pivot file and be able to automatically update each month?

Yes surely, but it's purely depends on how you constructed/structured your data

[Sarfaraz78615]

Yes Surely....i can help you if you send the excel file.