I Have the below data,
Business | Date | Value |
IT | Jan-24 | 1223 |
IT | Jan-25 | 156 |
IT | Jan-26 | 3123 |
IT | Feb-24 | 656 |
IT | Feb-25 | 1313 |
IT | Feb-26 | 66 |
IT | Mar-24 | 1646 |
IT | Mar-25 | 3323232 |
IT | Mar-26 | 41644 |
IT | Apr-24 | 56526 |
IT | Apr-25 | 2263 |
IT | Apr-26 | 1236232 |
Data Available for all the 12 months.
When I'm Transposing it this is becoming like below,
Business | Apr_24 | Apr_25 | Apr_26 | Aug_24 | Aug_25 | Aug_26 | Feb_24 | Feb_25 | Feb_26 | Jan_24 | Jan_25 | Jan_26 |
IT | 1223 | 656 | 1646 |
|
But i Want the output as below.
Business | Jan-24 | Feb-24 | Mar-24 | Apr-24 | Jan-25 | Feb-25 | Mar-25 | Apr-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 |
IT | 1223 | 656 | 1646 | 56526 | 1223 | 656 | 1646 | 56526 | 1223 | 656 | 1646 | 565 |
How to Achieve this?
Solved! Go to Solution.
I'm Using Crosstab only, the output of the crosstab is coming like this,
Business | Apr_24 | Apr_25 | Apr_26 | Feb_24 | Feb_25 | Feb_26 | Jan_24 | Jan_25 | Jan_26 | Mar_24 | Mar_25 | Mar_26 |
IT | 56526 | 2263 | 1236232 | 656 | 1313 | 66 | 1223 | 156 | 3123 | 1646 | 3323232 | 41644 |
Whereas it should be Jan-24,Feb-24,Mar-24,Jan-25,Feb-25,Mar-25,Jan-26,Feb-26,Mar-26
Sorry I missed the sort requirement. Recommend using Alex's solution
Adding something to the header will the change the Structure of the report. Is there any other way?
I am not sure I agree with that @Alteryxexpert - it is temporarily added to aid you and the Crosstab tool to order correctly, then removed with the Dynamic Rename to its original format.
@Alteryxexpert one way of doing this
@binuacs Is there a way to populate total under each column? Which should be dynamic if new months are added in future.
A Summarize won't pick the new data when used
@Alteryxexpert use the row total option in the cross tab tool