Chart Expression

[#1]

Hiii,

I am uploading an excel sheet in which i want those only customer name in chart whose net collectable is greater than 2.

Please help me out.

[sreenivas]

In u r excel sheet all values are greater than 2 .... what values to be filtered

[#3]

srry ...Value is greater than 3..

[sreenivas]

PFA

[jagan]

Hi,

Try this set analysis expression.

=sum({<Customer={'=Sum([Net Collectable]) > 3'}>}[Net Collectable])

Regards,

Jagan.

[#6]

hi

     step 1- add pivote chart

     step 2- take dimension                        Customer

     step 3- add expression and write       if([Net Collectable]>3,[Net Collectable])

hope this will help you

[#7]

Hi,

You can do this in the script or in the Chart Expression

Script:

LOAD Customer,

     [Net Collectable] as netCollectable

FROM

(biff, embedded labels, table is Sheet1$)

WHERE([Net Collectable] > 3);

Chart Expression:

=sum({<netCollectable = {">3"}>} netCollectable)

By

[neha_shirsath]

Hi,

you can try this.

if(Sum([Net Collectable])>3,([Net Collectable]))