I am trying to create a dynamic dashboard. 

I am wanting to create a dashboard that shows the specific sales against a sales team for each product against a quote. 

Additionally expected revenue for that sales team. 

I go and add a pivot table from the reporting to a spreadsheet but when i add a sales quotation it doesnt update the spreadsheet