transpose/pivot

[peanut89]

im prepping data for tableau for a visualisation and i need to pivot the annual revenue to make tableau read this better any tips...the current state is unreadable for tableau regarding the date format.

I would like to have the date in a column and corresponding revenue in the row beside... any ideas?

And yes there are other fields such as country, name product , as variables.

Thank you

[Felipe_Ribeir0 · Accepted solution]

Hi @peanut89 

You can adapt the attached workflow to do that.

Input

Output

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[Felipe_Ribeir0]

Hi @peanut89 

It worked? 

[peanut89]

Yes sir! thank you!