Hide rows in a straight table

[kdmarkee]

I have attached a qvw that shows the raw data and then a second chart that shows 3 rows I want to show and then be able to hide the others.  I have a requirement that calls for 2 separate criteria to dictate what rows should be shown and I'm not able to get a calculated dimension to work for hiding the necessary rows.  Thanks for you help.

[vishsaggi]

May be supress 0 values in your Presentation tab of the Straight table chart properties.

[kdmarkee]

That won't work because I need to show the zero rows for one half of the requirement.  In this example, the rows for Account 793 need to be displayed.

[sinanozdemir · Accepted solution]

Hi Kris,

How about this?

I added "0.00005" to Sum(Amount) when the conditions was met. Then in the format tab, I chose to show only two decimals

As a result of this, when you choose "suppress zero values", the rows that are met with the conditions would still show.

Let me know if this works

Thanks

[kdmarkee]

That is very clever, I never would have thought of that.  I will try it out and let you know.  Thanks.

[vishsaggi]

Thats a good idea. Sorry for late reply Kris. Was stuck with something. But probably you should be good with Sinan's idea.

[kdmarkee]

That seems to work, thanks again.

[sinanozdemir]

You'r welcome.

I am glad it worked.

Thanks