Aggr set analysis problem

[berkarmagan]

Hi everyone,

I ve a pivot table like example below. I ve got region, country, products and calculated dim as VisitDim. Sales and Visit on expression. My problem is visit data isnt related with products. I mean in expression i cannot split visit calculation by products. On calculated dimension i got true answer with this;

=AGGR(COUNT({<Products=>}DISTINCT CustomerID), Region, Country)

But when i put this on expression it doesnt work properly, first of all "Products=" make it trouble, selection on products doesnt work because of this.

How should i make my expression to get the same result like VisitDim. By the way can i use calculated dimension on expression with any column(columnno) function or sth like that? If not pls share your suggests about expression.

Thanks for now.

		Products	A		B		C
Region	Country	VisitDim	Sales	Visit	Sales	Visit	Sales	Visit
m	x	5	10		3	5	5	5
m	y	2	0		5		0
m	z	7	5		0		7
n	f	1	0		2		0
n	t	2	6		0		0

[marcus_sommer]

It's quite the same like: Pivot Table total func problem

- Marcus