Nothing really. I just want the report to be dynamic.
Let's say today, I want to run 2014 sales, and then later 2015 and then so on...
With your solution, I'll have to have 2014 spreadsheet and then 2015 Spreadsheet and so on... To use the 2014, I have to switch the views to look at 2014 spreadsheet. And switch again for the 2015.
The solution I have in mind is that the primary view will get the data directly from Adagio Tables which have tons of records. Using the primary views result (from tons of record to a constricted records), generate another view. My thought on this is that I'm trying to save the time from reading the whole table from Adagio just to get the second view.
Does it make sense?
Marlon