Number of fields who have the value "0" in a pivot

Flash0220

Board Regular
Joined
May 2, 2002
Messages
104
Hello,


I'm having the following little problem regarding pivot tables, and
I hope that someone can help me.

I have a database with (roughly) the following columns.

Column A = Employee code
Column B = End date 1
Column C = End date 2
Column D = End date 3
Column E = End date 4

In the B to E column is either a date (for example 20070816) or
the value "00000000".

Now I want to make a pivot table with "Employee code" in the page
field, so that I can select the various employee code's.

I want to use the fields "End date 1", "End date 2", "End date 3" and "End date 4" as data fields.

I want to count the number of cells of each of this 4 fields.

But i only want the number of cells counted of these 4 fields if the value
of these fields are "00000000".

Another (separate) pivot table has to do the same thing except in that
case the value of the fields "End date 1", "End date 2", "End date 3" and "End date 4" has NOT to be "00000000".

Is there a simple way to do this ?


Best regards,
Frits
(The Netherlands)
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

klb

Well-known Member
Joined
Apr 3, 2002
Messages
821
You can use the pivot table drop down boxes to include or exclude specific data from your pivot table results.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,110
Messages
5,599,776
Members
414,337
Latest member
ogoodheart

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top