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
