1. Need HTML , where it should contain the PIVOT table code for my source.
2. Every week when we add the excel file (data source) at a location , The HTML page
with Pivot rules should reflect the change (with a refresh button)
3. we have 5 different categories - different aging of the Tickets,
Incidents reported in the last week.
Throughput for the last week
Incidents pending for closure in last week
Incident backlog - Prior to the reporting week
Incident backlog -including reporting week
So all these 5 comes under different rules in PIVOT.
What i am looking is , as of now we are doing all the work manually , so the PIVOT rules should apply by default in HTML code, when ever we add the data source in file location, the data need to reflect with just a refresh buttons or other way.
All these will be uploaded in our share point. when the developed HTML page is uploaded in SharePoint, It should look like similar to share point dashboard.(little bit similar atleast)
UPLOADED THE FILE FOR YOUR REFERENCE WITH THE EXAMPLE AND SCREENSHOT