Gauge Chart Expression not display the data

[#1]

Hi community members,

I have the fields costs,sales,margin in my table, and when I am trying to create a gauge chart with the expression Sum({$<Years={2007}Sales)/Sum({$1}Sales), I am unable to get the gauge chart ,it displaying the not data to display .

In the same way Sum({$<Years={2007}Costs)/Sum({$1}Costs)

[MayilVahanan]

Hi

why you using $1 in Sum({$1}Sales)? Can you say it?

$1 -> previous selection value..

Edit:

Sum({$<Years={2007}Sales)/Sum(total Sales)

This will give result..

[jagan]

Hi,

Try like this

=Sum({$<Years={2007}Sales)/Sum(TOTAL Sales)

OR

=Sum({$<Years={2007}Sales)/Sum({1} Sales)

Hope this helps you.

Regards,

Jagan.

[#4]

Hi I have done like this I got the below gauge chart, thanks ramasamy

Sum({$<Years ={2008}>}Sales)/Sum(Sales)

[jagan]

Hi Ramesh,

I think you missed TOTAL or {1} in the denominator of the expression.

Regards,

Jagan.

[#6]

Thanks jagan,but I got the gauge chart correct only......I have another doubt, I have Sales field and Bill field,

when I am taking a chart with dimension as year and expression as Sum(sales), the sales bar  is showing the data same as Bill field data, can you suggest me, where might be the problem

[jagan]

Hi,

Can you post sample file with explanation.

Regards,

Jagan.