How to get Count on Pivot Table

[mdmuradkwt]

I wanted to know how to calculate and get the numbers on the attached spreadsheet. Please provide me the steps on completing the task.

Thanks,
Murad

 

[Debraj]

Hi Murad,

Did you tried.. by dragging "EEID" field to the Values Section..

 

[mdmuradkwt]

No, the fields identified are correct. i need the count on all blank areas.

Example on below.

I need total Asian in colomn EXP,FNA,FNE, Total.
Under row Asian need F count in coulum.

Same applies to all balnk field.

Annex EXP FNA FNE Grand Total
Asian
F
Add
Remove
M
Add
Remove
Black
F
Add
Remove
M
Add
Remove
Hispanic
F
Add
Remove
M
Add
Remove
White
F
Add
Remove
M
Add
Remove
Grand Total

 

[vijay.vizzu]

If i understand correctly... just drag actions tab in values field. It will give the count of all

 

[Debraj]

Can you please show a manual expected output.. from the attached..

 

[mdmuradkwt]

Can you please show a manual expected output.. from the attached..

View attachment 6365

This is what i needed.