Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I have the following problem: When I select a year, and some data doesn't exist for this year, how can I show the value 0 instead of the row not be shown? When nothing is selected, and the table is shown as table below:
Variable | Values - Sum(Valor) |
---|---|
A | 100 |
B | 200 |
C | 0 |
D | 30 |
F | 0 |
But if I select something, like year = 2015, since there's no data for row C and F, only the rows A, B and D are shown.
Variable | Values - Sum(Valor) |
---|---|
A | 30 |
B | 50 |
D | 10 |
That was exactly what I needed. Thank you Jonathan Poole.
Thanks to everybody that tried to help me. This code has worked, now I will just study it a little so I can understand it.
See you around
Hi,
I had a similar problem with the necessity to show the name of a a dimension in a simple table also if the expression's values are 0, that I resolved with a trick.
In the table I've defined an expression that is always true, than in the presentation tab I've hide it.
Now Work!!!