Hello All, Hope you all doing fine, I have this issue today where I have some sales values with me and I have to create a pivot based on it, Here is the sample data set. Table1: OECODeNameCompanySales111SidGoogle1500111SidEbay-1500111SidGoogle5000222PradeepAmazon2000333NitinZara3000 Result Table: OECODeNameCompanySales111SidGoogle5000222PradeepAmazon2000333NitinZara3000 So, From the above I have table 1 data with me it contains some negative values which should Nullify while summing all the values. Help me with this all.!!!! Regards, Sid

Not understanding how to use Summarize here.!!!

Hello All,

Hope you all doing fine, I have this issue today where I have some sales values with me and I have to create a pivot based on it, Here is the sample data set.

Table1:

OECODe	Name	Company	Sales
111	Sid	Google	1500
111	Sid	Ebay	-1500
111	Sid	Google	5000
222	Pradeep	Amazon	2000
333	Nitin	Zara	3000

Result Table:

OECODe	Name	Company	Sales
111	Sid	Google	5000
222	Pradeep	Amazon	2000
333	Nitin	Zara	3000

So, From the above I have table 1 data with me it contains some negative values which should Nullify while summing all the values.

Help me with this all.!!!!

Regards,

Sid

Developer

Developer Tools

Output

Tips and Tricks

Parse

Transformation

Optimization

Accepted answers

danilang

hi @siddharth207

The new one checks if the absolute values of the sales is >=1000. The ABS(SALES) is to avoid removing the negative rows.

Dan

Summarize.yxmd

All comments

danilang

hi @siddharth207

Here's my result with a simple summarize. The Values for Sid cancel out leaving a 0

Here's the configuration of the summarize tool

Dan

Summarize.yxmd

siddharth207

Hello danilang,

We need company name too with this. Also one row of name sid with sales 5000 is missing here.

Thanks for the help but we need some more accuracy.

reagards,

Sid

siddharth207

@BenMoss Need your HELP!!!!!!!!

Regards,

Sid

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703