Logic Required

[#1]

In list box i have the value data

Bucket

0-30

31-60

61-180

181-365

365+

Taking the above bucket as dimension and using the following expression sum({<PH_status='Commisioned',Net Collectable={"">$(vgreat)"}>}net collectable)

I get the following value

0-30       255

31-60     125

61-180    314

181-365  21

365+      123

Now my requirement is that when i select 0-30 value or other bucket, the chart should not show the value of that bucket whereas all other value should be seen. And if there is no selection then by default all value related to bucket should be seen in chart...

[#2]

hi

sum({1-$<PH_status='Commisioned',Net Collectable={"">$(vgreat)"}>}net collectable)

returns net collectable for everything excluded by the current selection.

[er_mohit]

sum({1-$<PH_status='Commisioned',Net Collectable={"">$(vgreat)"}>}net collectable)

[Gysbert_Wassenaar · Accepted solution]

Try

sum({1<Bucket-={'$(=only(Bucket))'}, PH_status='Commisioned',Net Collectable={"">$(vgreat)"}>}net collectable)

[#5]

Now how can i apply the above context with this formula

if(Dim='MW', num(sum({<PH_Status={Commissioned} , Net_Collectable={">$(vgreat)"}>}Order_In_MW),'##.##'),count({<PH_Status={Commissioned} , Net_Collectable={">$(vgreat)"}>}Prod_Hierarchy))