Can you please help me to create a pivot table for given result on result sheet and the raw data is on 1st sheet "data". its taking my lots of time to create it manually thanks in advance. i have uploaded the execl.
one thing in output which i exactly need if in one batch and same record no there is more than one field that i want to in one cell with "," seprate is this possible ? this is exactly i want like my result showing,
We may require one or more sheets for background calculations.
The data should preferably a Excel Table where different headers must go column wise and data should be entered row wise.
Now list out the items you want to show on your dashboard. Say you want your management to see month dashboard. So there must be an option to select the month. Now for that month what you want to show, here are some examples. no. of projects, project which hit the target, project which did not hit the target, how much %age rise or fall in each project, project which are continued to the selected month from last months and their status.
Likewise, you have to list what all you want to show.
If you are ready with all this than you can start creating the dashboard. If you are having some problem than write back, people here at chandoo will definitely help you out.
Yes you are correct with these option and one thing in this i want these dashboard of daily basis for like 10 to 15 projects. with my sample examples which i mention in excel sample, what you suggest me for it.
if you want raw data of my sample then i will provide it to you.