I have two files in my SQL database that I am wanting to link to excel. I have attached the format it is in SQL (nxtweek calculations)(and how I want it to show in Excel (schedule template). A couple of things:
- I want the daily calculations "hidden unless expanded"
- I want to Forecasted Sales & Total Scheduled COL not hidden and all other KPI's hidden unless Scheduled COL is expanded.
I have a few other requirements which I can discuss on the messaging service