How to write expression in dimension = that dimension/total sum

[#1]

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......

[ToniKautto]

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.

[#3]

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..

[#4 · Accepted solution]

Hi

Your expression should be :

=Count( ApplicantID)   /Count(TOTAL <Date> ApplicantID)

JJ

[#5]

Alright it works, thanks a lot..