Single filter for several dimensions

Kavadera

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

	Apr	May
4	1273	7429
5		5527

 

Miran

Status changed to: New