Dear All,
i want to get a last 03 month value not add month field to chart. (WITHIN TWO YEARS TURNING POINT)
I WANT BELOW
JAN 2017 = VALUE
DEC 2016 VALUE
NOV 2016= VALUE
NOT USING BELOW
| | YEAR | 2016 | 2016 | 2017 |
| BCOD | MONTH | 11 | 12 | 1 |
| CO01 | | 26,315,373 | 22,448,666 | 21,284,113 |
| CO02 | | 3,085,912 | 1,867,994 | 4,292,186 |
I using given below expression
FIRSTLY I SELECT JAN 2017
01. 2017 JAN (CURENT MONTH) = Sum ( {$<DESCRIPTION= {'GROSS_PREMIUM'},DESCRIPTION= {'NRP'} >} [Actual]) THIS ALREADY WORK
02. 2016 DEC = SUM({<TRAN_MONTH={'$(vPriorMonth)'},DESCRIPTION= {'NRP'} >} [Actual]) THIS IS COME TO ZERO VALUE
03. 2016 NOV =SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) THIS IS A WORK
SECONDARY I SELECT FEB 2017
01. 2017 FEB (CURENT MONTH) = Sum ( {$<DESCRIPTION= {'GROSS_PREMIUM'},DESCRIPTION= {'NRP'} >} [Actual]) THIS ALREADY WORK
02. 2016 JAN = SUM({<TRAN_MONTH={'$(vPriorMonth)'},DESCRIPTION= {'NRP'} >} [Actual]) THIS IS A WORK
03. 2016 DEC =SUM({<TRAN_YEAR={'$(prioryear)'},TRAN_MONTH={'$(vPriorMonth-1)'},DESCRIPTION= {'NRP'} >} [Actual]) THIS IS COME TO 2015 DEC VALUE
I USING INPUT BOX IT IS GIVEN BELOW
| vMaxdate | = | 01 Jan 2017 |
| vPriorMonthYear | = | 2016 |
| vMindate | = | 01 Jan 2017 |
| prioryear | = | 2016 |
| vMaxDay | = | 31 |
| vPriorMonth | = | Dec |
| vPriorMonth-1 | = | Nov |
| vPriorMonth-2 | = | Oct |
| vPriorMonth-3 | = | Sep |
| vPriorMonth-4 | = | Aug |
| vPriorMonth-5 | = | Jul |
| vPriorMonth-6 | = | Jun |
| vPriorMonth-7 | = | May |
| vPriorMonth-8 | = | Apr |
| vPriorMonth-9 | = | Mar |
| vPriorMonth-10 | = | Feb |
| vPriorMonth-11 | = | Jan |
| vPriorMonth-12 | = | Dec |
| vPriorMonth-13 | = | Nov |
| vNextMonth | = | Feb |
PLEASE HELP ME
SAGARA
