Select moore months in Set Analys

[#1]

Hello,

is it possible to get this?

If I select a year and lets say febr and mars  and get the result for the same months in a set analysis like this?

this is what I have stored in a variable for Last Year Month Today and of course I only get the last mont in my selection.

Can I change it in some way to get the two selected months?

PeriodID = {$(=Max(PeriodID) - 12)},

Year = {$(=Max(Year)-1)},

Quarter = ,

Period = ,

Month =

Håkan

[adamdavi3s]

OK so you're selecting Year and Month?

If so then

sum({<PeriodID={">=$(=Max(PeriodID) - 12)"}>}yourfield)

as this will in theory show all 12 months, but because you've selected month it will restrict it.

Sorry if I have missed the point the requirement isn't totally clear to me

[#3 · Accepted solution]

Hi,

I'm not sure if I understand your case correctly but If you just want to show value for selected months from the year before theoretically you don't have to use PeriodID. That should be enough:

sum({$<Year = {$(=Max(Year)-1)}>} Field)

If you select Year and Jan,Mar you will get sum from Jan and Mar from the last year.

BR,

Milosz

[#4]

If I choose like this:

I get only the value of mars in LYMTD when I use this, it works fine when you select only one

mont but not if you select more months.

PeriodID = {$(=Max(PeriodID) - 12)},

Year = {$(=Max(Year)-1)},

Quarter = ,

Period = ,

Month =

[hemachandran]

HI,

Try This Expression

=sum({$<CstFiscalYear={$(=max(CstFiscalYear)-1)}>}UnitActual)

Dont use period PeriodID in your expression..

[adamdavi3s]

Ok what is your formula for LYMTD?

[sasiparupudi1]

Use a period range

ex:

PeriodID = {">=$(=Max(PeriodID) - 12)<$(=Max(PeriodID))"}

Year =,

Quarter = ,

Period = ,

Month =

hth

Sas

[adamdavi3s]

or just PeriodID={">=$(=Max(PeriodID) - 12) as i suggested above.

<$(=Max(PeriodID)) is a given, assuming of course you meant to write <=$(=Max(PeriodID))

[neha_shirsath]

Hi,

I'm not sure i got your point correctly, means you want to show rolling 12 months?

sum({<cal_yr=,cal_month_abr_name=,cal_prd=,cal_prd_seq ={"<=$(=max(cal_prd_seq)) >$(=max(cal_prd_seq)-12) "},

>}Sales)

Thanks & Regards,

Neha S.

[adamdavi3s]

In fact why not ditch the period totally, you don't need anything for it at all

PeriodID =,

Year = {$(=Max(Year)-1)},

Quarter = ,

Period = ,

Month =