community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Pivot Table data by month

 

Hi,

 

I read all discussions about Pivot Tables like in Excel, but still cant find the way how to  display data like below image. 

 

I am trying to  display category and subcategory per month. 

 

Thank you.

Screenshot_3.jpg

 

Highlighted
Magnetar

Hi @Vlad_Kutateladze

 

Here is a solution that gets you close.  The trick is to break it down into Line item, Subtotal and Grandtotal record sets  and then use a combination of joins and unions to build up the final table

 

Pivot.pngWF.png

 

 

Dan

Quasar

Here is the sample workflow for your case.  Hope this is helpful. 

 

workflow.PNGWorkflowResult.PNGResult

Meteoroid

I had similar issue to contend with!  Going to check out the below solution and see if that does the job.

 

Stan

Labels