How to show different value in popup and chart value.

[wangxusq]

Hi ,

I have a requirement, pls see the picture:

I created a chart, the bar chart measure is sum(quantity)/1000;

I need the bar chart value is sum(quantity)/1000  and the popup value shows sum(quantity).

For example, if sum(quantity)=1528123, then the bar chart value shows 1528  and the popup value shows 1528123.

It also would be OK if it can be  achived    in mashup.

Thanks.

[dplr-rn]

Try using dual function

Dual(text, number)

something like Dual(sum(quantity), sum(quantity)/1000 )

[wangxusq]

Hi,

Thanks for your response. I tried  it according to your method, but it doesnot work.

It still keeps the same value. Any idea?