Hi,

I am building an Executive dashboard which have bunch of metrics out of which not all are at same level. These metrics come from multiple sources.

Eg: No. of sales is at Date>>Category level.

      No. of customers is at Date level

Filers available for this dashboard are Month,Week & Category.

What I am trying to achieve is that, when a user does filtering on "Category", the metrics which are not at category level shouldn't show up.

Is there any way to achieve this?

Thanks in advance

Sampat