Not understanding how to use Summarize here.!!!

[siddharth207]

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

[danilang]

@siddharth207 

Here you go.  This workflow is dependent on the input data being exactly as described.  

[siddharth207]

Hello Dan,

Sorry to trouble you more. Your solution worked perfect but there is one more condition just adding that here. have a look

Table1:

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

We need to take only whose sales is greater than sales>1000

So result would be same but need to incorporate this condition

Result Table: 

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

[danilang · Accepted solution]

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

[siddharth207]

Awesome! We hit it! Thanks a ton Man!