Triggers applied using button - urgent help

[#1]

Hi All,

I have a four buttons in a single sheet , based on the selection of buttons the charts are shown up uisng Layout condition. I have a button called sales in which if I click on the button five charts should come up (4 Bar charts and one  Table box) . I need to populate fiew fields in the Table box out of which I have a field named Status  (which has True and False as values) . I need to show only true values in the table box but as i cant apply any conditions in the table box I am not sure how to do this..

If you have any better approaches for implementing  the same plz share..

Awaiting for the reply..

Thanks in advance..

[CELAMBARASAN]

Hi,

     On that button use the action Select in field with FieldName as Status and search string as True.

Hope it helps

Celambarasan

[vijay_iitkgp]

Hi,

You can add a trigger  Selection on button Sales. In  Filed put Status and in Search String put True/Flase whatever u need.

[#4]

The problem is the condition  (TRUE) gets applied for all teh charts instead of applying only to table box which i dnt want..

Thanks

[swuehl]

Why not use a straight table instead of a table box, with calculated dimension or set expression to limit status to TRUE?

[CELAMBARASAN]

Hi,

     Then you can go for straight table instead of table?any specific reason to use table box here?

Celambarasan

[vijay_iitkgp]

In All oher chart use set analysis to ignore Status Field :Eg

Sum({$<Status =>} Sales)

[#8]

Yes. I have changed it to Straight table with expression as 1 and hide the  expression.. Also I have added the calculated dimension on the Status filed to pick only (TRUE) values.. Hope this is correct ???

[CELAMBARASAN · Accepted solution]

Hi,

     Use Status in Expression like =if(STATUS='TRUE',1) instead of 1.

Celambarasan

[#10]

Hi Vijay,

yes that was helpful..

Thanks