Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT in Pivot tables
I have some data that looks like this
Date item amount 25/2 apple 10 25/2 organe 20 26/2 apple 15 26/2 lemon 12 I am able to get a Pivot table with the COUNT of items with a 'Calculated Field'? I need to do it in a calculated field, because I need to do some other other calculations as well. I have my calculations and they work. However because the pivot table will change whidth and hight and order of things, I would like it to be there as a calculated field. Is this possible? houghi -- Always listen to experts. They'll tell you what can't be done, and why. Then do it. -- Heinlein : Time Enough For Love |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count pivot tables | Excel Worksheet Functions | |||
Count in Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot tables - Sum instead of Count | Excel Discussion (Misc queries) | |||
Pivot tables: SUM not COUNT!!!!!!!! | Excel Discussion (Misc queries) | |||
Sum vs. Count in Pivot Tables | Excel Discussion (Misc queries) |