Converting Basic Table to Desired Table

[rively90]

Hello!

I'm wondering if anyone knows how to convert the data from the basic table to the desired table (see the excel pic). Also, I'm wondering if we can have dynamic filtering in this case. I'm planning to have dynamic filtering on the year and quarter. Should we just make a graph for that one? Lastly,  does anyone know how to make a percent change from the previous quarter to the current quarter? What should I do?  I hope someone can help me with this. I appreciate your time!!

[JarekSkudrzyk]

@rively90 

hi, I guess your problem was solved in this post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/change-on-the-table/td-p/917153