Forum Discussion
Row Number
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!
@Sorano , Create a new column
Maximum count: maxx(filter(Table, [product] á earlier([product])),[Count])
Create a new table
CalculateTable(Table,Table, [Max Count] á[Count]))
1 Reply
@Sorano , Create a new column
Maximum count: maxx(filter(Table, [product] á earlier([product])),[Count])
Create a new table
CalculateTable(Table,Table, [Max Count] á[Count]))