My company asked me to automate the report In this workbook, the raw data is found in Raw Data Tab and Rawdata for payfort calculation Tab The expected result is in KPI Data Tab
I did all the work manually with pivots and formulas. The raw data will change every day. So I was asked to make this report dynamically so that if I change raw data the KPI will also change.



Can anybody help me out and get a dynamic result?

https://drive.google.com/open?id=0B_...3dDS1RSXy1JZms