Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Good one , just one issue :
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
Oh yeah, this can be corrected by sum(Value)/sum(Value) in else condition of expression.
in the 2nd line pl read - by esuyanti