Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Not understanding how to use Summarize here.!!!

siddharth207
7 - Meteor

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:

OECODeNameCompanySales
111SidGoogle1500
111SidEbay-1500
111SidGoogle5000
222PradeepAmazon2000
333NitinZara3000


Result Table:
 

OECODeNameCompanySales
111SidGoogle5000
222PradeepAmazon2000
333NitinZara3000

 

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

 

 

13 REPLIES 13
danilang
19 - Altair
19 - Altair

@siddharth207 

 

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

 

WF.png

siddharth207
7 - Meteor

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:

OECODeNameCompanySales
111SidGoogle1500
111SidEbay-1500
111SidGoogle5000
222PradeepHP900
222PradeepAmazon2000
333NitinZara3000

 

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:
 

OECODeNameCompanySales
111SidGoogle5000
222PradeepAmazon2000
333NitinZara3000

 

danilang
19 - Altair
19 - Altair

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.

 

WF.png

 

Dan

siddharth207
7 - Meteor

Awesome! We hit it! Thanks a ton Man!

Labels