ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   COUNT in Pivot tables (https://www.excelbanter.com/excel-discussion-misc-queries/178016-count-pivot-tables.html)

houghi

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


All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com