Hi, I am interested to create a workflow where the following input will give the following output:
Input
Item Code | FY | Revenue |
ABC123 | 19 | 1111 |
ABC123 | 20 | 2222 |
ABC123 | 21 | 3333 |
DEF456 | 19 | - |
DEF456 | 20 | - |
DEF456 | 21 | 4444 |
Output
Item Code | FY | Revenue | Revenue Count |
ABC123 | 19 | 1111 | 3 |
ABC123 | 20 | 2222 | 3 |
ABC123 | 21 | 3333 | 3 |
DEF456 | 19 | - | - |
DEF456 | 20 | - | - |
DEF456 | 21 | 4444 | 1 |
Any kind soul can help pls :)
Thank you in advance
¡Resuelto! Ir a solución.
Hi @dhakim1996
Here is a solution for you: Firstly Filter out where Revenue does not equal -, then group by Item Code and count Revenue. Join back to the main dataset on Item Code, and perform a quick calculation to remove any counts where Revenue equals -
Hi @dhakim1996
One way of doing this.
Output:
Kindly accept this solution if it provided a solution to your question.
Many thanks
Shanker V