Say you have project that have sale that are limited in time:
| | Jan | Feb | Mar | Apr | May |
| 1 | 1284 | 2075 | | | |
| 2 | | 8643 | 6534 | | |
| 3 | 1877 | 440 | 5010 | 1889 | 8324 |
| 4 | | | | 1273 | 7429 |
| 5 | | | | | 5527 |
| 6 | | | | | |
I would like to be able to filter both the projects and the months at the same time. So that when I select the summary level only useful data is shown. Let's say the last three projects are assigned to Brand X. I want to have a NONZERO filter that would show me the following data when selecting Brand X in a dashboard (with synchronization enabled):