How to ignore selection in a table

[#1]

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

[#2]

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

[davdiste]

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!!!