bar chart issue

[#1]

Hi Experts,

                   I have to  show the data in single bar with indicator like guage chart, if count(sales)>50 green color remaining is gray color.

                i'm attaching the sample document please give me your suggestion to modify.

Regards,

Mike

[vikasmahajan]

Qvw is opening please create and attach again

[its_anandrjs]

Please attached the snap shot for the requirement.

Regards

Anand

[HirisH_V7]

Hi,

is this,

using value list,

Create a dimension: =ValueList('Sales')

Expressions: =if(ValueList('Sales'),'Sales',Sum(Sales))

                  =if(ValueList('Sales'),'Sales',Sum(Sales)/2)

HTH,

PFA,

Hirish