Creating Category from columns for waterfall chart 'breakdown'

Question

I have 3 columns each containing relevant values for clothing.I have month data that I can filter by and I can also create summations.&nbsp;How would I add this data to a category so that I may filter by only shoes or only shirts?&nbsp;I want to use this data in a waterfall chart, but I require this informaiton for use in the breakdown component.&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Shirts:&nbsp; &nbsp; &nbsp; &nbsp;Shoes:&nbsp; &nbsp; &nbsp; &nbsp;Pants:month1&nbsp; &nbsp; &nbsp;+25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; +2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; +6month2&nbsp; &nbsp; &nbsp;-3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; +14month3&nbsp; &nbsp; &nbsp;+33&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; +15&nbsp;&nbsp;

jthomson · Accepted Answer

Unpivot the columns so you get three columns - month, type of clothing and value

Forum Discussion

Creating Category from columns for waterfall chart 'breakdown'

1 Reply

Related content

Waterfall chart with specific breakdown order

Waterfall Breakdown logic

Waterfall Chart - Sorting breakdown

Waterfall chart - change breakdown order

Wanna Create Waterfall Visual