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):