Group By and Count

[dhakim1996]

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

[binuacs · Accepted solution]

@dhakim1996 One way of doing this

[DavidSkaife]

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 -

[ShankerV]

Hi @dhakim1996 

One way of doing this.

Output:

Kindly accept this solution if it provided a solution to your question.

Many thanks

Shanker V