Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help in pivot
Hi,
I have data like this A1 A2 A3 A4 B1 B2 B3 xx xxxxx sdsds sdsdsd 12 10 11 df sdsdd dffdd sdsd ds 11 11 11 fgf fgfdgs ggfrtr hhjfdf 14 13 10 i want a pivot table on this like below: A1 - Team Name A2 - Task Name B1 = Wk1 Total B2 = Wk2 total ...... i want these above in pivot table. all of the above fields on top row. Can somebody help? Thanks, Vijay |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help in pivot
Assume your data looks like this:
Team Task Code Wk1 Wk2 Wk3 Ac Cbd A13 3 8 5 Aa Cbd C12 1 4 4 Da Bea C12 7 5 8 Aa Fda C12 9 8 8 Ac Cbd A29 5 1 6 Aa Cbd A13 4 1 7 Ac Bea A13 2 4 8 Aa Fda C12 1 3 6 Ac Cbd A29 2 3 4 Fc Aad E13 3 6 9 Aa Cbd C12 6 6 3 Aa Fda C12 9 5 7 Aa Cbd A13 2 2 7 Ea Fdb C12 9 8 2 Then you can create a Pivot Table to look like this: (just a small sample) Team Task Code Aa Ac Cbd Fda Bea Cbd Data A13 C12 C12 A13 A13 A29 SumWk1 6 7 19 2 3 7 SumWk2 3 10 16 4 8 4 SumWk3 14 7 21 8 5 10 You can choose Team, Task or Code to go into ROW and/or COLUMN. I chose... Layout: Drag Team, Task and Code into COLUMN Drag Wk1, Wk2, Wk3 into DATA (Sum of ....) Options: Uncheck Grand Totals, AutoFormat, hide subtotals. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |