Hai,
I have to prepared cost statements on monthly basis of revenue budget with Chart of account like:Account, Organisation, location, budget,expenses,Funds Available,and % used,
I currently using Pivot Table to filter these data and Want to use DASHBOARD
I work as budget control and have to creat various MIS based on 1.Budget,2.Expenses,3.Available Funds, and these data have to mention on 3 months periods like from JUL-to-SEP, OCT-to-DEC, JAN-to-MAR, and APR-to-JUN,
my report on pivot table some thing like this...