Forum Discussion
How to create a column with a filter for grouping
| month | currency | sales | sales/month | %currency/month |
JAN | eur | 10 | 30 | 33,33% |
| JAN | usd | 20 | 30 | 66,66% |
| FEB | eur | 5 | 20 | 25% |
| FEB | usr | 15 | 20 | 75% |
Hello, I try to create the sales/month column but I can't get the result expected. I want to have the sum of the sales for all rows where the month is the same. Any Idea please ?
Anonymous ,You can get month sales anew column like
sumx(filter(table,[month] =earlier([month])),[sales])
2 Replies
- amitchandak
Super User
Anonymous ,You can get month sales anew column like
sumx(filter(table,[month] =earlier([month])),[sales])