Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am having a problem with pivot table.
How can I write an expression to show a value in each dimension = its own value / total partial sum in that dimension.
Would be much appreciated if anybody answer......
Hi
Your expression should be :
=Count( ApplicantID) /Count(TOTAL <Date> ApplicantID)
JJ
Please provide exaple data and a sample of what you expect your pivot table to look like. To exemplify the pivot you could for exampl stage a excel sheet as mockup of your expected pivot.
Hello,
This is how it looks like. Value in table #TTD derives from Count(ApplicantID)
I'd like to create table %TTD Distribution. The value derives from this formula:
Count(ApplicantID) * 100 / Total in table #TTD
For example, value for New to Bank in 31/01/2011 is
33.3333 = (2*100) / 6
Hope this is clear enough....
I use Partial Sum function and not sure how to write its expression.
Thanks a lot in advance..
Hi
Your expression should be :
=Count( ApplicantID) /Count(TOTAL <Date> ApplicantID)
JJ
Alright it works, thanks a lot..