Skip to Content
avatar image
Former Member

Query designer: How to hide result line independantly in a ratio structure

Hi experts,

I want to be able to hide some result in my ratio structure, but all my structure is acting as a whole. Either they are all displayed, either they are all hidden.

hide-result.png

I want to do that because for some ratio, the result line are mixing different units so the result is not relvant.

==> goal is only to display the YI result, and hide all the others result lines.

I tried several strategy:

- In ratio properties, when is chose "calculate as" "hide" it's still displaying the result line despite it's empty.

- Query properties -> hiding null value : still showing the result line if there is value for the ratio in my time structure.

I'm also using the report in Analysis but it seems the option are the same as in the query designer.

Is it possible to do something ?

Thanks a lot for your help.

hide-result.png (17.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers