Bar Chart dimensions & expressions

[#1]

This is very basic question for you all but I need some help.

I have this data in excel sheet showing consumption in sectors A to D from Year 2001-2020. Please help me create a bar chart. What can be the dimensions and expressions for this

Thanks,

Mandy

[#2]

See file attached!

Regards

Rahul

[#3]

Thanks so much Rahul. Appreciate that!

If I have around 200 rows of data or more, then I cannot write each and every value in my script. So how would I show this data? Please see attached file.

[#4]

Dear Mandy,

In the image you posted there is only one dimension (looks like state), plus the headers are missing. I had  taken your test data set literally. However I am sure your dimension is clubbed under one head.

If possible please post an example.

Regards

Rahul

[#5]

Am so sorry! PFA... Consumption per product in each State. I know its not that good of an example

[#6]

Dear Mandy:

You could try like:

Assuming you load the data depicted as TempData try the following script:

FinalDate:

Load

'Product1' as Product_Cat,

State,

Product1 as Amt

Resident TempData;

Outer Join

Load

'Product2' as Product_Cat,

State,

Product2 as Amt

Resident TempData;

and so to consolidate your Dimensions

then drop the temp table.

Hope it works!

Regards

Rahul