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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Pivot Table data by month

Highlighted

 

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

 

Nebula

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

Asteroid

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

 

Stan

Labels