Qs- % in Pivot table

[Karahs]

Hello everyone,

              We have created a pivot table in which one dimension is called as process and one coloumn called as month and two measure called as COUNT(CLIENTCODE) and ?????????????????????? 

So i want to remove % in that other measure, to remove percentage i used COUNT(TOTAL(CLIENTCODE)  which is giving me an wrong answer. Is this the right way if not please suggest me what to do?

eg. COUNT(TOTAL(CLIENTCODE))

ie. 101/238*100 = 42%

But i am getting answr as 10%, Because it is taking all months total, if i want to take only one month total how do i do that?

Please help!!!

Thanks

[sunny_talwar · Accepted solution]

Try this:

Count(CLIENTCODE)/Count(TOTAL <MonthField>CLIENTCODE)

[trdandamudi]

Can you please post a sample app..

[Karahs]

Thankyou so much it worked