Hi, I am interested to create a workflow where the following input will give the following output: Input Item CodeFYRevenueABC123191111ABC123202222ABC123213333DEF45619-DEF45620-DEF456214444 Output Item CodeFYRevenueRevenue CountABC1231911113ABC1232022223ABC1232133333DEF45619--DEF45620--DEF4562144441 Any kind soul can help pls :) Thank you in advance

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

Datasets

Input

Tips and Tricks

Common Use Cases

Preparation

Expression

Accepted answers

binu_acs

@dhakim1996 One way of doing this

Count_1128.yxmd

All comments

binu_acs

@dhakim1996 One way of doing this

Count_1128.yxmd

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 -

Count.yxmd

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335