Data issue in Pivot table

[dasaradh]

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

[Anonymous]

Could you share your expression??

[Anonymous]

Do some thing like this:

Denmark Expression:

(Count({<Country={'Denmarl'}, Flag={'Active'}>} distinct Customerid)

/

Count({<Country={'Denmarl'}>} distinct Customerid))*100

Similar for other countries....

[dasaradh]

hi

exp is

count({$<[ActiveAcctInd]={'Y'},$(vFilterLastDay)>} distinct CustomerNbr)/ count({$<$(vFilterLastDay), LineType={Normal}>} distinct CustomerNbr)

[sunny_talwar]

What is the expression you are using currently?

[dasaradh]

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