Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please check enclosed file...
Do not check the following option:
Chart properties -> Presentation -> suppress zero values
Please check enclosed file...