calculate exactly like Pivot tables in sql
I have sanpshot coming daily which gives the information of how and what sales we did for that day and it all formulates under ship to fiscal week, year , product, invoices, amount, etc.
So what shall be my best approach to make it automated. I know we have distinct function in SQL which gives me quick win, so I dont have to manually and sort the unique invoices and calculate that particular Product under it. What shall be my best approach and which charts I shall formulate this kind of forecasting. Do anyone have exposure to make it in story telling dashboard ?
my daily snapsot looks like this,
Also my user like to see historical data from 2015 and going forward.... Also they are comparing their data with targets they set starting of each year( which is hard coded).