memonawais
New Member
Hello,
I am currently creating a dynamic dashboard.
I want to be able to see on a pivot table and on a chart, data visualized by Department-wise.
I want this without using VBA.
I have following columns in my data:
Budget head, Month, Commitment ID, Demand Number, Department, Initial Commitment Amount, Actual Expenditure.
I have to show Departmental wise data. User may select department as per their choice and view the information of that Dept only.
Thank you for your ideas and experience
I am currently creating a dynamic dashboard.
I want to be able to see on a pivot table and on a chart, data visualized by Department-wise.
I want this without using VBA.
I have following columns in my data:
Budget head, Month, Commitment ID, Demand Number, Department, Initial Commitment Amount, Actual Expenditure.
I have to show Departmental wise data. User may select department as per their choice and view the information of that Dept only.
Thank you for your ideas and experience