Bar Chart

[#1]

Hi,

I have a weird requirement. I have a chart with a cyclic group of 'Employee' and ''Designation'. I have Sales1 and Sales2 in the expression. My requirement is like, when I cycle through Employees, I should get Sales1 and sales2 in the bar chart and When I cycle it through Designation, I should see only Sales2. Is this Possible? To be more clearer, Please look at the attachment.

[#2]

Hi,

This can be achieved, when you have your dimension as drill down.

I doubt , this can be achieved r not,

May be some one can help you.

- Sridhar

[#3]

Hi,

Just write the following expression in your Sales1 and it will work according to your requirement..

=

if (count(Designation)=1,Sum(Sales1),0)

regars..

Afzal

[#4]

Hi,

Thanks for the suggestion. But, still I am not able to implement your logic in my application. See the attachment.

I have a field Des1 in the table T2 only. I need to include a spinner which has two fields (Name1 from T3 table and Des1 from T2 table). So, when i spin through Name1, the result is correct, But when I spin through Des1, the result is not correct as it takes value for T1 also, which does not have a value for Des1. Please look at the attachment.

Is it possible to achieve my requirement in the front end (expression) rather than altering the script.

[#5]

I tried with this

if

(count(Designation)=1,Sum(Sales1),0) .It's wokring but you need to figues how to change the legend accordingly