Help. I want to sum by Vendor across Quantity Range (1-99, 100-499, 500-1000). Basically 1 column for each field (instead of 3 for Vendor). Notice how the Vendor can change as the quantity increases. Thanks PartVendor1-99Vendor100-499Vendor 500-1000 13242314ACME$20ACME$15ACME$10 14212412SPECIALIZED$150SPECIALIZED$125CERVELO$75 q4623523COMPANY-A$300COMPANY-B$200ACME$100 UPDATE.... Desired output Vendor1-99100-499500-1000

Merge Vendor Fields and Sum

Help. I want to sum by Vendor across Quantity Range (1-99, 100-499, 500-1000). Basically 1 column for each field (instead of 3 for Vendor). Notice how the Vendor can change as the quantity increases.

Thanks

Part	Vendor	1-99	Vendor	100-499	Vendor	500-1000
13242314	ACME	$20	ACME	$15	ACME	$10
14212412	SPECIALIZED	$150	SPECIALIZED	$125	CERVELO	$75
q4623523	COMPANY-A	$300	COMPANY-B	$200	ACME	$100

UPDATE....

Desired output

Vendor	1-99	100-499	500-1000

Tips and Tricks

Transformation

Help

Accepted answers

AngelosPachis

Hi @hellyars ,

One way r=to do that would be with the following workflow

Essentially you are pivoting your data multiple times to bring the table in the proper structure which will allow you to aggregate the values for each vendor and make it as dynamic as possible.

Hope that helps.

Regards,

Angelos

example.yxmd

Qiu

@hellyars
Figure you would need the Part Field

1231-hellyars.yxmd

All comments

AngelosPachis

Hi @hellyars ,

One way r=to do that would be with the following workflow

Essentially you are pivoting your data multiple times to bring the table in the proper structure which will allow you to aggregate the values for each vendor and make it as dynamic as possible.

Hope that helps.

Regards,

Angelos

example.yxmd

Qiu

@hellyars
Figure you would need the Part Field

1231-hellyars.yxmd

hellyars

@AngelosPachis I've never used the CEIL function before, it will come in handy. Thanks!

Tyro_abc

I used simple select and union to achieve this.

Best Regards

Vendor_Product.yxmd

hellyars

@AngelosPachis I ran into a real world problem. The Group expression stopped working part way through a workflow and started assigning null() at would have been Group 256.

This is where it stops working.

Screen Shot 2020-12-31 at 9.22.49 AM.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703