Running Total count

[faisal9999]

I have data in the attached image. I want the result as shown in the output cell...I want to see the result like total or running total or count - 5 after every pair of unique date ends

[cjaneczko]

You could use a Summary Tool and group by Date and then Count the number of records. Then union that back to the original data set and sort by date. Use a formula tool to add the text "Total or Running total count row -" + [Count of Records]. 

[dkungu]

Hi @faisal9999 

For running_total you can add recordid for each unique date 

then use a multi-row tool to get running total 

[binuacs]

@faisal9999 use the running total tool and group by the date

[faisal9999]

thank you all for the solution but unfortunately its not giving the result I am looking for...

[Qiu]

@faisal9999 
I asume the flow of @binuacs should match what you show on the screen shot.
Can you give more details about the not giving the result you are looking for?

[faisal9999]

If you see at the image There is ID and date once unique date is over that should give me the no of row count then from next row new unique date will start something like that

[Qiu · Accepted solution]

@faisal9999 
We can simply use a Summarize tool to count the number of record for each date then union back.

[AgusEP]

Or maybe that you want is something like this?
(just a slight visualization change of solution from Mr. Qiu above)

Spoiler

 

[faisal9999]

thank you guys you all solved my problem thanks once again :)