Excluding a Dimension

[Anonymous]

Dear all,

In qlikview, I have a data base in that way, as below:

Status	Year	Product Category	CBU	Family	Jan	Fev
FCST	CY	Cars	1	L	29	34
FCST	CY	Cars	1	M	67	64
FCST	CY	Cars	1	H	14	22
FCST	CY	Cars	2	L	9	9
FCST	CY	Cars	2	M	7	9
FCST	CY	Cars	2	H	5	7
MKT	CY	Cars		L	1	1
MKT	CY	Cars		M	0	0
MKT	CY	Cars		H	11	21

I have a problem: I'd like to show all MKT volumes when I choose any CBU (1 and/or 2). But MKT appears as a "blank" CBU dimension

What should I do?

Regards

[kfoudhaily]

so this should be ok:

sum({$<CBU= >}Jan)

whatever value from CBU calculate sum