Hide and Show a Column

[#1]

hi everyone,

Is there a function or something to hide a column in a table?, or , how can i manipulate the conditional option to do this??, plz anyone

Regards,

Carlos

[#2]

I dont know how to explian you what i have to do but i will print screen my app and maybe it will be more clear, look:

This is my dashboard on my app:

when i click in any value

then a chart appear:

this last table cover all the dashboard, actually the only way to go back to the second image is clicking in back button or clear all seletions, i need to go back to the second image without clearing the selections or without cliking on back button, do i made myself understandable?? any ideas??

[johnw]

OK, I guess I see what you're doing. My suggestions are the ones I already said, then, "set up a button to set a variable using a macro or action, and then set up the field so that when selections are made or changed, it sets the variable differently, then use the variable in the show condition for the chart" or "using the minimize button on the chart".

The first option sounds more like what you want, but it's quite a bit of work and I don't think I have any examples. Maybe someone has an example lying around, though.

Really, I'd probably just use the minimize and not have a button. The minimized chart isn't taking up much more room than a button, and to me, it makes more sense to click on a chart to see it and minimize when you don't want to see it, rather than click on a selection to see it, and clear the selection or click on a button to make it go away.

[#4]

Thanks John, I found the answer with a macro.

[#5]

Hi,

I'm having problems using Conditional. e.g. I use a simple table with customers and sales. If I only want to show the columns where sales > 100 I would use "sum(Sales)>100". Unfortunately this isn't working. Someone an idea. Thanks.

Aloah

[johnw]

This is a condition. It evaluates to true (-1) or false (0).

sum(Sales)>100

This is using that condition to decide whether or not to establish a value for the column. It evaluates to sum(Sales) or to null. Nulls are suppressed by default. So this will only show the rows where sum(Sales)>100.

if(sum(Sales)>100,sum(Sales))