can someone give me an advise whats the best way to transform the table so that the result chart (pivot) is looking this way:
category | yearmonth | acutal | plan 1... 2... 3...
At first I thought about load yearmonth and categoryX_actual and plan for each category witth an addtional field that contains the category ('category1'), and concatenate them so I can use category as a dimension.
