Expression in bar chart

[Anonymous]

Hi ,

I am trying to write an expression in a bar and line combo chart.

when I am writing below expression the value is coming different in the chart and different in Straight table.

Expression in Straight table- I have Region as a dimension in staright table which is having value apac and emeia.

Premium value : NUM(ROUND(SUM({<Month=,TDimMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}TSummary.Value)))

Expression in Bar Chart

Premium Value : Sum({<Month=,TMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}if(Region='APAC',TSummary.Value))

Sum({<Month=,TMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}if(Region='EMEIA',TSummary.Value))

Please help how can i write the expression in bar chart which will give the same value as in straight table.

[Anonymous]

Hi Nikita,

Pls share the sample data so that I can try for solution

Thank you.

[PrashantSangle · Accepted solution]

in both chart are you using same dimension?

By the way you can optimize your expression like.

Sum({<Region={'APAC'},Month=,TMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}TSummary.Value)

Sum({<Region={'EMEIA'},Month=,TMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}TSummary.Value)

[Anonymous]

Thanks Prashant.

It worked.