2015 External Sales Budget/Forecast Tool

[Analyst_Newbie]

Hello people.

I was wondering how I should go about creating a useable sales report for products.

Basically need to create a table in a structure way to identify (Av sell price = Revenue/Volume). In terms of structure I think I should be ok.

The problem is that the reports needs to be adjustable to allow the flexibility to input volume and ASP adjustments by product and customer and add/average accordingly. As there there is a incredible amount of data - attachment is only small entry of data just wondering what is the best way on going about it.

I was think of integrating it into a pivot table format but in saying that can it be adjustable when changing figures in the pivot table - (linking the changes into the amount of data)?

Any help is much appreciated. Refer to attachment for brief idea on what the hell im talking about

 

[bobhc]

Good day and welcome to the forum if you have not already done so please read this link.

http://chandoo.org/forum/forums/new-users-please-start-here.14/


As to your question a Pivot Table would handle this for you and the large amount of data, with a PT you can quickly change your reports and data input would update the PT.


.

 

[Analyst_Newbie]

Thanks for that, can we change it vice-versa - when you change results in the PT then it will update in the database?

 

[Analyst_Newbie]

Let me repharse, it is possible that the table of data & pivot table is autolinked?

 

[bobhc]

The PT is linked to the data table, how else could it pivot data that it is not linked to?

 

[Analyst_Newbie]

i get what you mean. but i was wondering if it is possible to change data/values in the pivot table where in turn updates the changes in the original data source?

Refer to attachment for better understanding. note that i took about 90% of the database due to the size of the file but still has the structure

 

[bobhc]

Why do you want to change the values in the PT, you change the values in the data table and the pivot displays the data in the way you want