I have a data source as given below,
with
Previous month as (=Sum({<Temp={"<=$(=Num(Month(Today())))"}>} Value)) one expression,
future month as (=Sum({<Temp={">$(=Num(Month(Today())))"}>} Value))one expression and
YTD as (=Budget-Sum({<Temp={"<=$(=Num(Month(Today())))"}>} Value)-Sum({<Temp={">$(=Num(Month(Today())))"}>} Value)) another expression
I need to show in straight table with linear gauge chart.
I am getting the output as attached image lineargaugechart.png
But my expected linear gauge chart should be given in lineargaugechart_expected.png
anyone can help me!
Regards,
Yoganantha Prakash G P