Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

Transpose data per month

Ar13f
10 - Fireball

Dear All,

 

I have the data like below :

 

Input Goods 1.png

 

and I want the output of the above report is as below: 

 

Output Goods 1.png

 

 

5 REPLIES 5
binay2448
11 - Bolide

Please find solution attached...

Ar13f
10 - Fireball

Dear @binay2448 

 

thanks for the solution, but what I expect is not the sum ... what I want is that the ticket data is still counted as one data with the same value every month. So, Jason has 2 items from a ticket with a value of 1000 that I want to take is a ticket with a value like below Output Goods 1.png

Elias_Nordlinder
11 - Bolide

Hello @Ar13f ,

 

You can remake @binay2448  version a little bit like this.

I summarized the values first and took the first value for each month/Ticket/Name.

 

Elias_Nordlinder_0-1630909780218.png

Elias_Nordlinder_1-1630909809293.png

 

 

 

Let me know if this meets your requirements 🙂

//Regards
Elias

binay2448
11 - Bolide

Find attached updated one....

Ar13f
10 - Fireball

Thank you for your solution, @binay2448 and @Elias_Nordlinder .... done ... you're all great 

Labels