Forum Discussion
Anonymous
2 years agoNot applicable
adding calculated column with group by
Hi all,
I would like to add to each line a calculated column based on a group by:
| customer | sales rep | product | tot |
| C1 | S1 | P1 | 3 |
| C2 | S1 | P1 | 3 |
| C3 | S1 | P1 | 3 |
| C7 | S1 | P2 | 1 |
| C4 | S2 | P1 | 1 |
basically I would like to add a column that shows how many records I have for each sales rep/product couple
regardless of which customer bought it.
Many thanks in advance.
pls try this
1 Reply
- AhmedxSuper User
pls try this