Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have a pivot table it having 3 countries data
like this
Denmark | sweden | norway | |
---|---|---|---|
customers | 19459 | 28822 | 28088 |
active customers | 15508 | 21535 | 15476 |
customers/active customers% | 79.7 | 68.8 | 61.3 |
for denmark customers/active customers% result is correct but for sweden and denmark i am getting wrong values?
can some body help me in this
thanks in advance
thanks,
dasaradh
Could you share your expression??
Do some thing like this:
Denmark Expression:
(Count({<Country={'Denmarl'}, Flag={'Active'}>} distinct Customerid)
/
Count({<Country={'Denmarl'}>} distinct Customerid))*100
Similar for other countries....
hi
exp is
count({$<[ActiveAcctInd]={'Y'},$(vFilterLastDay)>} distinct CustomerNbr)/ count({$<$(vFilterLastDay), LineType={Normal}>} distinct CustomerNbr)
What is the expression you are using currently?
hi Sunny,
count({$<[ActiveAcctInd]={'Y'},$(vFilterLastDay)>} distinct CustomerNbr)/ count({$<$(vFilterLastDay), LineType={Normal}>} distinct CustomerNbr)
this the exp i am using
pls help me in this
thanks,
dasaradh