Summarize tool

[gavinwong]

Hi Community,

absolutely new in this. need abit of help. 

Attached is the file that I am trying with the Summarize tool.

This is something I would use very frequently due to the number of unique records I need to count each time.

In this very simple setup,

I am expecting the following results

4 unique IDs (which is correct)

4 distinct sales because there 4 different sales numbers (why is it counting 5 ? )

4 names are correct

4 months ie there are 4 different months jan feb mar april ( why is it counting 5 ?)

2 Married (either yes or no, why 3 ?)

4 distinct years because 5,8,9,7 are 4 different numbers. ( why 5 ?)

Appreciate any help given

[zkhadi]

Hi Sure.

This is how my output should look like. (example)

Currently this is what I have....

So I can sum the number of days traveller has spent in one country. But I need to sum the number of flights he has taken to that particular destination. I also have an arrival date columns as well. PLS HELP? 

I hope this make sense ? 

[Storm]

Does something like the attached work?

[zkhadi]

Yes it worked. Thank you so much !!!