Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pivot table subtotals
i have a report which has 250 columns and 1000 rows. i'm creating various
pivot tables with the data in the columns. if i create a pivot table on height (column) and weight (row), i get the data i need. is there a way to create a subtotal on just the weight 150? all of the weights are in actual lbs, so i've got a range from 101 lbs to 212. it's a bit cumbersome to uncheck or check all of the fields in the pivot table to filter it out. thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pivot table subtotals
Hi Ann,
Weight is a row field, yes? If so put your cursor in the weight field of the pivot table and choose the command Pivot Table, Group and show detail, Group. Set the by to 150. This may do exactly what you want, if not you can create a calculated field or item which takes longer to set up. Yet a third method would be to modify the data source to include a new field Over 150, use a formula like =B1150 then this now field with return TRUE if over 150 otherwise FALSE. Put this field in the pivot table as a row field to the left of the weight field. -- Cheers, Shane Devenshire Microsoft Excel MVP "Ann" wrote: i have a report which has 250 columns and 1000 rows. i'm creating various pivot tables with the data in the columns. if i create a pivot table on height (column) and weight (row), i get the data i need. is there a way to create a subtotal on just the weight 150? all of the weights are in actual lbs, so i've got a range from 101 lbs to 212. it's a bit cumbersome to uncheck or check all of the fields in the pivot table to filter it out. thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pivot table subtotals
when i click group, i get an error: cannot group that selection. how do you
set it to 150? "ShaneDevenshire" wrote: Hi Ann, Weight is a row field, yes? If so put your cursor in the weight field of the pivot table and choose the command Pivot Table, Group and show detail, Group. Set the by to 150. This may do exactly what you want, if not you can create a calculated field or item which takes longer to set up. Yet a third method would be to modify the data source to include a new field Over 150, use a formula like =B1150 then this now field with return TRUE if over 150 otherwise FALSE. Put this field in the pivot table as a row field to the left of the weight field. -- Cheers, Shane Devenshire Microsoft Excel MVP "Ann" wrote: i have a report which has 250 columns and 1000 rows. i'm creating various pivot tables with the data in the columns. if i create a pivot table on height (column) and weight (row), i get the data i need. is there a way to create a subtotal on just the weight 150? all of the weights are in actual lbs, so i've got a range from 101 lbs to 212. it's a bit cumbersome to uncheck or check all of the fields in the pivot table to filter it out. thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table subtotals | Excel Discussion (Misc queries) | |||
Pivot Table subtotals | Excel Discussion (Misc queries) | |||
Pivot Table Subtotals | Excel Discussion (Misc queries) | |||
Subtotals in a Pivot Table | Excel Discussion (Misc queries) | |||
pivot table row subtotals | Excel Discussion (Misc queries) |