Hello All,
I am working on full accumulation in pivot chart by using Rangesum and Above function.
I am using Aggr in expression and Limiting time period by using variable for From date and To date.
By applying Rangesum , I am getting correct Accumulation for desired period, but getting 0 value for before desired time period and Last value remain constant for after time period.
Eg. If I am considering time period from 1st April, 2017 to 15th April 2017, I am getting 0 values for 1st Jan 2014 to 31st March, 2017 and 15 is constant for 15th April, 2017 onward.
Kindly help to remove these 0 Values and these constant values.
Thanks in advance...
My Exp:
if(Dimensionality()=6,
RangeSum(Above(SUM(AGGR(Count({<POSTING_NUM={">=$(vStartDate)<=$(vEndDate)"},TIME_INTERVAL_STATUS={'DELAY'},QV_REPORT = {'Page Release'},DATE-={' '},DATE_TYPE={'Distinct'},
QV_FLAG={'Time'}>} DISTINCT POSTING_NUM),STATE,PLANT,EDITION_DESCPRTION,
CALENDER_PROD_DATE,QV_REPORT)),0,RowNo())),
SUM(AGGR(Count({<POSTING_NUM={">=$(vStartDate)<=$(vEndDate)"},TIME_INTERVAL_STATUS={'DELAY'},QV_REPORT = {'Page Release'},DATE-={' '},DATE_TYPE={'Distinct'},
QV_FLAG={'Time'}>} DISTINCT POSTING_NUM),STATE,PLANT,EDITION_DESCPRTION,
CALENDER_PROD_DATE,QV_REPORT))
)