Empty values as 0

[#1]

Hello,

My data table looks like this:

store	date	month	sales
a	1/1/2014	1	100
a	1/2/2014	1	150
a	2/1/2014	2	200
b	2/1/2014	2	300

And I have a “month” list box:

month

1

2

I need to create a straight table in which all stores appear, regardless of the month chosen. If there is no value for the store in the data table for the chosen month, I need to have the number 0 in the table. For example, if the user chooses month 1 from the list box, the straight table should look like this:

store	sales
a	250
b	0

Any idea?

Thanks

[gmoraleswit]

Do not check the following option:

Chart properties -> Presentation -> suppress zero values

[MK_QSL · Accepted solution]

Please check enclosed file...