Pivot table Calculation Help

[amit_saini]

Hi Folks ,

I have a pivot table :

Dimmension: STDDATE , Location

Expression : Sum(Values)

Requirement : I need to divide "CHESTERFIELD" values with other location row wise.

e.g for STDDATE- 2015-08-17 . the entire row need to be divide by 47 , similarly for 2015-08-18 row should be divided by 46 and so on...

Kindly suggest how this can be achieved .

Thanks,

AS

[amit_saini]

Good one , just one issue :

[amit_saini]

Looks like this will work:

if(Location<>'CHESTERFIELD',sum({<Location-={CHESTERFIELD}>} Value)/sum(TOTAL<STDDATE> {<Location={CHESTERFIELD}>} Value) ,sum({<Location={CHESTERFIELD}>} Value)/sum(TOTAL<STDDATE> {<Location={CHESTERFIELD}>} Value))

Thanks,

AS

[Digvijay_Singh]

Oh yeah, this can be corrected by sum(Value)/sum(Value) in else condition of expression.

[Digvijay_Singh]

I mean in the expression shared by SergeyKostin

or you can use the one by

or mine one...:)

[Digvijay_Singh]

in the 2nd line pl read  - by esuyanti