current vs previous vs same period last year

[singhcv123]

I have a requirement and for that i have a table .....

KPI

-----------

FInancial Year

Period code

Count

Booking

Now as per table i want 3 expression

(1) Current period ---that is just the value of field Count for selected Period COde

(2) Previous period-  please suggest

     sum({<Period code ={Num(Period Code)-1)}>}Count)               ///but not working ...

(3) Same period last year ---please suggest how to generate a set expression for the same....

please suggest....

[trdandamudi]

It will be very helpful to test if you can share a sample file with expected output:

1) Not Clear

2) Sum({<Period code ={'[Period Code]-1'}>} Count)   

3) Need more details

[singhcv123]

HI PFA attached QVW fiLE AND PLEASE suggest the right set expression.......

[trdandamudi]

See if the below is helpful, if not can you please post the expected output:

1)  =Count(Count)

2) =Sum({<[Period code] ={'[Period Code]-1'}>} Count)  

3) =Sum({<[Financial Year] ={'=[Financial Year]-1'}>} Count)  

[singhcv123]

not getting desired outcome by applying this....