Need Count of Each Value in one Column Field

[Oakley]

Have the attached datapage report currently.  I need to have each color in the second column counted and that count next the color. For example it should finish like...numbers are just guesses, not accurate.

Lime  43

Orange 26

Royal 20

Black 14

Yellow 8

Red 11

Purple 12

Pine 4

Gray 12

Navy 2

What is the best way do that ?

Towel List By Event.pdf

[autonumber]

Hi @Oakley - if you want to count the color based on the id/player, you can add a calculated field in your report and use this formula: [@field:color] + (SELECT COUNT([@field:color]) FROM TableName WHERE ID=target.[@id])

[Kronos]

Hello @Oakley,

You can also achieve a similar output via a Pivot table datapage. You can follow this setup:

Here is my data set:

And here's the result:

 

An advantage I can think of using Pivot table is that you can enable drilldown option to view the names assigned on a color

If you clicked on the color count, the datapage will display the names like this:

You can read more about it here:

https://howto.caspio.com/datapages/reports/pivot-table/

 

I hope this helps!