asked on
Excel Pivot help
Hi all,
From last few hrs i have been trying to make a Pivot table, Column "C" "Task" based Person based Count.
Wanted the work done by
How many Voice, Editing, Camera, Anchor work did "Micheal" do
If anyone can help me would be great
attached sample file
Thanks in advance
Sample.xlsx
From last few hrs i have been trying to make a Pivot table, Column "C" "Task" based Person based Count.
Wanted the work done by
How many Voice, Editing, Camera, Anchor work did "Micheal" do
If anyone can help me would be great
attached sample file
Thanks in advance
Sample.xlsx
Microsoft OfficeMicrosoft ExcelMicrosoft ApplicationsSpreadsheets
Last Comment
mtthompsons
ASKER
Thank you, can you help me with a sample excel please
Not sure what you mean, what do you want a sample of?
ASKER
You said
Your data just isn't in the right format for producing a pivot table like that.
What you should have are columns for Date, Work Type, Person and Task.
But those data are as Columns, so i am not sure how to change them
Your data just isn't in the right format for producing a pivot table like that.
What you should have are columns for Date, Work Type, Person and Task.
But those data are as Columns, so i am not sure how to change them
You have 4 columns for Work Type, you should only have one, see the attached file.
Sample-Reformatted.xlsm
Sample-Reformatted.xlsm
ASKER
Thanks, but its one task which multiple people do, adding them 3 or 4 times for one task would be tough, any other ways please?
ASKER
Example
A Video is produced
1 Person Shoots it
2nd person edits it
3rd person gives a voice over
4th may do graphics
A Video is produced
1 Person Shoots it
2nd person edits it
3rd person gives a voice over
4th may do graphics
Something like attached may help you...
PivotReformatted.xlsx
PivotReformatted.xlsx
ASKER
Shums report is as i wanted but as mentioned above is it only way that i add same entries multiple times to achieve this?
Yes,
As mentioned by Norie, your sheet needs formatting to achieve what you are looking for.
As mentioned by Norie, your sheet needs formatting to achieve what you are looking for.
ASKER
So each entry we need to place multiple times?
Unfortunately Yes :)
Hi,
In my opinion there are two another possible approaches to solve the issue :
1- Formulas to count the data (Check the attached file FormulaWork Sheet).
2- If you are using version that has "Power Query" you can use it to reformat the data to tabular data (Check the attached file PowerQuery Sheet).
Br,
Abbas Abdulla
Sample.xlsx
In my opinion there are two another possible approaches to solve the issue :
1- Formulas to count the data (Check the attached file FormulaWork Sheet).
2- If you are using version that has "Power Query" you can use it to reformat the data to tabular data (Check the attached file PowerQuery Sheet).
Br,
Abbas Abdulla
Sample.xlsx
ASKER
abbas abdulla superb thanks,
Can i know steps to do it and i have office 2007 and 3013
Can i know steps to do it and i have office 2007 and 3013
IF you have 2013 excel - see this video to have idea about the steps done https://youtu.be/vztnlZhHzos
ASKER
Thanks, data from Table option is not found in my excel, i have 2013 professional
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks a lot
What you should have are columns for Date, Work Type, Person and Task.
With that set up you could easily produce the pivot table you describe, and even take it further by grouping by Date, filtering by Work Type etc.
If you have a version of Excel that supports Power Query/Get & Transform Data... you could easily change the layout of the data to make it conducive to the creation of a pivot table.