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

hi @siddharth207 

 

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

 

WF.png

 

Here's the configuration of the summarize tool

 

Summarize.png

 

 

Dan

siddharth207
7 - Meteor

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

danilang
19 - Altair
19 - Altair

Hi @siddharth207 

 

Where does the 5000 come from.  It's not in your input data, unless you sum the values for 222 and 333.  

 

Dan

siddharth207
7 - Meteor

Hello Danial,

Sorry for the incorrect data. Just Updated.

 

Regards,

Sid

danilang
19 - Altair
19 - Altair

I see the new data now.  For the question of the company name in the output how do you decide which company to put in?  In the following data set, what would the output record be for Pradeep and how did you calculate it?

 

OECODeNameCompanySales
111SidGoogle1500
111SidEbay-1500
111SidGoogle5000
222PradeepAmazon1000
222PradeepGoogle1000
222PradeepEbay-1000
333NitinZara3000

 

Dan

siddharth207
7 - Meteor

Hello Dan

An OECODe will not have more than 2 sales value same under it. on the combination of OECODe/Name.

 

 

Regards,

Sid

siddharth207
7 - Meteor

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

 

 

Regards,

Sid

danilang
19 - Altair
19 - Altair

hi @siddharth207 

 

So, if I understand correctly, your input data will always have either 1 row per client, like 222 and 333 OR 3 rows for each client  with the 1st 2 rows reversing each other with the same amount? 

 

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

 

Are there any other possibilities?

 

Dan

siddharth207
7 - Meteor

Yes Exactly!

Labels