| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Pivot Table Processing
Yes and now I see it. Thanks
"topola" wrote: Daniell, I can not see how far you are so let me start from the very beginning. For ease of use I would name the range as "Data" for further references. 1) Select range with your data. 2) Insert Name Define "Data" Add or just type in the name in the left up window (where "A1" stands) and press Enter. Each of the headers in this range must have a unique name. 3) Add column between Days and Qty (Insert Column) 4) Name it Days10. 5) Select column with Days and name it "days" 6) Right to "23" in Days10 column type =IF(days<10,0,1) 7) Copy that formula for the cells in this colum. 7) Create Pivot Data Pivot Table... ... range: type in "Data" with no apostrophes, create Pivot Table 8) Drag Days10 and Days into Row Field, Months into Column field and Qty in Data Field. 9) Make sure that you use Sum not Count for Qty unless you don't want to count the instances of appearance. 10) On Days10 right click and choose Group and Show Detail Show Detail Please let me know where you are. Tomek |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Threaded Mode
