Simulating a Pivot Table for a Data Source

Hello, I have a data set with multiple value columns that I would like to simulate a pivot table with. Attached are the columns i am working wtih. I would like to combine the Weeks portion of this so i have a total output by Store Nbr, UPC, and their Total POS sales, POS Units, Net Ship Retail, adn Net Ship Qty. If it is possible i would also like to filter out certain weeks. Can someone help me with the workflow and configurations for this?

Workflow

Input

Connectors

Accepted answers

grossal

Thanks for the sample data @dewoods17!

Here is your workflow:

Settings of the Summarize Tool:

Output:

I'll attach the workflow for further testing. Please let me know if this solves the problem and mark it as as solution if it does or drop another question and I'll do my best to help 😃

Best

Alex

2020-03-26-pivot.yxmd

All comments

grossal

Hi @dewoods17,

it would be useful if you drop some sample data (as a file) and a screenshot (or file) from the desired output. This would allow us to create a sample workflow.

Anyway - here are the steps you need to perform:

1) Filter Weeks

You can use the Filter tool to achieve this.

2) Pivot data

Use the Summarize tool for it. Set Store Nbr, UPC, Total POS sales, POS Units, Net Sthip Retail, adn Net Ship Qty to "Group by". (e.g. select the Store Nbr column, click 'add' and than 'group by')

Lastly add a Sum for total output (not sure if I got this right because I don't see a total output column in the screenshot).

Hope this helps a bit. Drop some sample data (or DM it to me) and I'll build a workflow for you 😃

Best

Alex

dewoods17

Thanks for your help. here is an example of my input and desired output

Pivot Table.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703