Counting Unique Rows

[JeffGrant]

Hi all I have a table with thousands of rows.

The table is made up of three columns.

Race Track, Race Number, Entrant Name.

There is around 40 Unique Tracks
Each Track can have up to 20 Races
Each Entrant can appear up to 10 times per race. (my Data contains historical performances)

How can I use PQ to count the number of unique entrants per race per track?

Thanks in advance.

 

[Matt Allington]

To use PQ, you would need to do a groupby using the columns that identify uniqueness. The number of rows in this table is the answer

 

[JeffGrant]

I can do it by:

1. in PQ remove duplicates
2. Close and Load to a New Table
3. Create a pivot table
4. use the Excel GetPivotData function,

 

[JeffGrant]

Thanks Matt....

How do I use Group BY on more than one column?

 

[JeffGrant]

thanks Matt. I found it.

 

[JeffGrant]

Hi Matt,

I can group by Track, then add race number, but when it comes to the counting of the entrants, PQ wont give that option. Any ideas what I am doing wrong?

 

[JeffGrant]

Got it..