A
Ann
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.
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.