How to show data horizontally in a Pivot Table

Hi Community,

I am having issues using the crosstab tool to create a pivot table to show transactions of product for two years lined horizontally instead of vertically. If anybody can help with this, I really appreciate it... Newby here using cross tab tool.

Thankyou!!!

TestHL.docx

TestHL.yxmd

Transformation

Accepted answers

apathetichell

Your order of operations was a bit off. Here's how I'd approach it... IRL I'd probably do something via batch macro to make it a bit more dynamic - but this should get you where you need to go.

pivoted breakdowns.yxzp

All comments

Raj

Please try using attached Examples with tool
Also add some sample excel Data to help with workflow.

grromerro

Hi!, The data is in the text input in the workflow Thank you so much

Swathi

Is this what you are after?

grromerro

Hi Swathi,

I can't copy and paste the image here, but I have attached the file with what I need to recreate. Basically, it is the data by year as you have it below, but also breaking down the info per month in a column for each year. Is that possible?

Thank you!!

TestHL.docx

apathetichell

Your order of operations was a bit off. Here's how I'd approach it... IRL I'd probably do something via batch macro to make it a bit more dynamic - but this should get you where you need to go.

pivoted breakdowns.yxzp

grromerro

This is Amazing! thank you for sharing and helping to solve this! I really appreciate it!

grromerro

Hi Community,

Following with this same case, does any of you know how to make the Summarize tool dynamic so that when a new record for a new month is added in the attached workflow, then it can be included in the pivot table. In the example attached, February transaction is not being captured by the summarize tool,

Thank you so much.

pivoted breakdowns.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703