Different Charts in Straight table

[yoganantha321]

I have a data source as attached.

I need to display the output as shown in the straight table.png image

I have used Budget in linear chart and status in traffic light chart.

My need is :

I have a month as one dimension which must show the value month wise in each column as shown in image.

[HirisH_V7]

You can use pivot table and drag the dimension as cross table.

Else if  you want it to be in straight table means, you can check by doing a cross table load in script and transpose the month dimension as a work around.

HTH,

Hirish

[yoganantha321]

can you clear describe the steps

[HirisH_V7]

Do Check this app,

[yoganantha321]

But I need the status as one column not to be repeated as shown in above image

[jyothish8807 · Accepted solution]

Hi,

In that case you might have to write separate expression for each month.

refer the sample attached.

Br,

KC

[yoganantha321]

I got it.

Thanks Jyothish.