Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi,
Use Status in Expression like =if(STATUS='TRUE',1) instead of 1.
Celambarasan
Hi,
On that button use the action Select in field with FieldName as Status and search string as True.
Hope it helps
Celambarasan
Hi,
You can add a trigger Selection on button Sales. In Filed put Status and in Search String put True/Flase whatever u need.
The problem is the condition (TRUE) gets applied for all teh charts instead of applying only to table box which i dnt want..
Thanks
Why not use a straight table instead of a table box, with calculated dimension or set expression to limit status to TRUE?
Hi,
Then you can go for straight table instead of table?any specific reason to use table box here?
Celambarasan
In All oher chart use set analysis to ignore Status Field :Eg
Sum({$<Status =>} Sales)
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 ???
Hi,
Use Status in Expression like =if(STATUS='TRUE',1) instead of 1.
Celambarasan
Hi Vijay,
yes that was helpful..
Thanks