Forum Discussion

yashgoyal's avatar
yashgoyal
New Member
4 years ago
Solved

Cluster Column Chart for column type data

Please help how to generate Cluster Column Chart for column type data on this type of data GL Dept Current JAN Current Feb Current Mar Current Apr 152955 4 4 4 4 153365 57 57 57 ...
  • mahoneypat's avatar
    4 years ago

    You need to unpivot your data in the query editor. Select your GL Dept column, right click and choose "unpivot other columns". You will then have a three-column table including two new columns called attribute and value. You can rename those to month and whatever your values are, and then make your chart using the Month column as the legend.

     

    Pat