Straight Table chart

[bharatkishore]

Hi All,

I have a straight table chart and added few dimensions and expression.

Now I need to see data for all the months like below one where ever data is there it should come for all the months and where data is not there it should show 0.

But when i include the original formula for Cons field the chart is showing for only months where  data is available like below:

Can you please help me how can i achive it. Attached app for more ref

Thanks,

Bharat

[YoussefBelloum · Accepted solution]

Hi,

you can modify the conso formula to this:

Sum({1}Consumption)

or you can uncheck this option on the presentation tab:

[bharatkishore]

Thank you so much..

[YoussefBelloum]

You're welcome !

Good luck