dynamic columns in Straight/pivot table chart

[Krish]

Hi,

I am trying to create a chart/table which has 2 dimensions, country and type and a measure sum(sales). My input would be like

and output like below

How can this be achieved? 

[NITROG3NN]

Hey Krish,

   Try using Pivot chart and just drag the Dept column above your expression and you will get what you want. Check the attachments.

[Krish · Accepted solution]

This is what I was looking for. Thank you.

Is there a way to suppress Dept (field name header) from the pivot ?

[NITROG3NN · Accepted solution]

You cant suppress it fully, but try this, reduce the size of the column and label it blank in dimension tab (use space, screenshot attached below) and you will be left with the screenshot below.

[NITROG3NN]

If the topic is resolved please mark the right answer.