Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I wan to change KPI object value based on period... for example I select Jun month period.. then I should be able to get May month revenue or I select May month I should be able to see April month. I would appreciate to provide any support
$40K | 35K |
Period | field | amount |
XTD - Jun-17 | Revenue | 40000 |
XTD - Jun-17 | COR | 35000 |
XTD - May-17 | Revenue | 35000 |
XTD - May-17 | COR | 32000 |
XTD - Apr-17 | Revenue | 50000 |
XTD - Apr-17 | COR | 25000 |
Do you have a Date field?
No I don't have date field...
Bhawnesh,
Please do the following steps:
1. calculate month and year according to a field.
a. using Purgechar function your date should calculate.
2. Calculate month Year.
Date(Date#(PurgeChar('XTD - Jun-17','XTD - '),'MMMYY'),'DD-MMM-YYYY')
2. Write set analysis as Below .
Sum({<Date={$'(=addmonths(Max(Date),-1))'}>}Amount)
Thanks,
Arvind Patil
That is not working ...I added your date expression but it is displaying 01-Jun-2017.but when I checked normal functioning stopped working