Total missing in Pivot Report

[mohdhaniff]

Hi,

I'm having problem how to get Total in expression for 'Achievement'. : -

Column 1 : December

sum({$<[Date Disbursed - Month]={'$(=max([Date Disbursed - Month]))'}>} [ETP Amount]))

Column 2 : Achievement

column (1)   /
if(index([Make Segment II],'New Nation')>0,120000000,
if(index([Make Segment II],'New Foreig')>0,120000000,
if(index([Make Segment II],'Used')>0,120000000,
if(index([Make Segment II],'Recondi')>0,40000000,
if(index([Make Segment II],'Other')>0,0,
if(index([Make Segment II],'Enterpr')>0,0,0))))))

Expected Result

Actual Result:

[adamdavi3s]

Ok so as I suggested, if you change the total mode it works, you need to tell us what output you're expecting here

[mohdhaniff]

Hi gysbert,

Thanks for your comment. You giving me an idea.

I got the answer... the achievement should be write as below:

column (1)  /
if(index([Make Segment II],'New Nation')>0,120000000,
if(index([Make Segment II],'New Foreig')>0,120000000,
if(index([Make Segment II],'Used')>0,120000000,
if(index([Make Segment II],'Recondi')>0,40000000,
if(index([Make Segment II],'Other')>0,0,0))))))

(120000000+120000000+120000000+40000000) // Amount targetted only

[mohdhaniff · Accepted solution]

Thanks Adam,

I got it. I Change 'else' value with a value as below

column (1)
/
if(index([Make Segment II],'New Nation')>0,120000000,
if(index([Make Segment II],'New Foreig')>0,120000000,
if(index([Make Segment II],'Used')>0,120000000,
if(index([Make Segment II],'Recondi')>0,40000000,
if(index([Make Segment II],'Other')>0,0,if(index([Make Segment II],'Enterpr')>0,0,120000000+120000000+120000000+40000000))))))