How to use conditional set analysis in KPI object

[#1]

  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

[OmarBenSalem]

Do you have a Date field?

[#3]

No I don't have date field...

[arvind_patil]

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

[#5]

That is not working ...I added your date expression but it is displaying 01-Jun-2017.but when I checked normal functioning stopped working