Hi
I am attaching this file, this workbook runs the SLA between the 02 timeframes and does the conditional formatting as per the macro, if you look the sheet SLA it has run the macro, I am using the 23rd dec data, also I have got 23rd graph sheet , which has the pivot table which capture the volumes from the SLA sheet, which updates the graph, I have to calculate the within SLA figures by doing filtering and its time consuming, is there any way I can add calculated field in pivot table or some other way of capturing the within SLA figures so it can update the graph dynamically.
Green colour means its with SLA which is less than 1 hour
and red colour means outside SLA which is over 1 hour.
please advise.
thanks
Tauqeer
I am attaching this file, this workbook runs the SLA between the 02 timeframes and does the conditional formatting as per the macro, if you look the sheet SLA it has run the macro, I am using the 23rd dec data, also I have got 23rd graph sheet , which has the pivot table which capture the volumes from the SLA sheet, which updates the graph, I have to calculate the within SLA figures by doing filtering and its time consuming, is there any way I can add calculated field in pivot table or some other way of capturing the within SLA figures so it can update the graph dynamically.
Green colour means its with SLA which is less than 1 hour
and red colour means outside SLA which is over 1 hour.
please advise.
thanks
Tauqeer