Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
It's quite the same like: Pivot Table total func problem
- Marcus