Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
Count(CLIENTCODE)/Count(TOTAL <MonthField>CLIENTCODE)
Can you please post a sample app..
Thankyou so much it worked