Row Number

[Sorano]

Hi!

I have table with days, some product and count of this product. I need to create table where will be max count of product and day where it was.

For example what i have: 

Days	Product	Count
Monday	phone	27
Monday	milk	10
Monday	table	15
Tuesday	milk	15
Tuesday	table	3
Tuesday	phone	20
Wednesday	milk	15
Wednesday	coat	14

I need table where will be:

Days	Product	Max Count
Monday	Phone	25
Tuesday	Milk	15
Tuesday	table	3
Wednesday	coat	14
Wednesday	apple	28
Wednesday	pen	10
Thursday	notebook	4

How i can do this?

Thanks!

[amitchandak · Accepted solution]

@Sorano , Create a new column

Maximum count: maxx(filter(Table, [product] á earlier([product])),[Count])

Create a new table

CalculateTable(Table,Table, [Max Count] á[Count]))