Variable as expression in Chart

[Anonymous]

Dear Experts,

I am storing a values in Variable says Total Sale and now I have to use this variable as expression in Bar Chart as expression across a Dimension say Zone wise...

But when I am using in Bar Chart taking dimension Zone and expression as VTotalSales...

It is showing me same figure across all zones...

Pls suggest, why it is?

Regards,

Balraj

[arulsettu]

HI

check your variable

and expression should be $(VTotalSales)

[jonathandienst]

Hi

Of your expression is Sum(Total Sales), then you are telling QV to ignore the chart dimensions, so it will be the same for all dimension values

HTH

Jonathan

[Anonymous]

Jonathan,

Is it solvable??

[SunilChauhan]

in variable expression itselef write

aggr(Sum(Total Sales),Zone )

or simply use sum(Sales) as variable expression