Pie chart problem

[venkey2847]

Hi all,

I have to create one Pie chart.

I am deriving dimension fields by using measures.

If(wrsale<10000 and (wrsale-exsale)<50000),''yes',

'no') as indicator.

If(indicator= ''yes','high','Low') as result.

Now I need to create a pie chart with the dimension.

How can I take expression.

The expression should be like above if condition.

Because I need to show the percentage.

Please help me out on this issue.

Thanks

Venkey

[YoussefBelloum]

Hi,

before creating the barchar, when you calculate the INDICATOR field:

If(wrsale<10000 and (wrsale-exsale)<50000),''yes',

'no') as indicator.

if wrsale is lowel than 10000, so wrsale-exsale will always be lower than 50000..

so maybe change it to this:

If(wrsale<10000 OR (wrsale-exsale)<50000),''yes',

'no') as indicator.

I'm I right ?

[Digvijay_Singh]

Do you have sample to share here? Not sure but may be -

Dimension-

Aggr(If(indicator= ''yes','high','Low') ,indicator)

Measure -

Count(indicator)

Not sure if it will work, sample will help to understand it better