Set Analysis previous three month

[ceccannito]

Hi everybody,

i need to calculate a number of suppliers of three previous month.

I have to build a table of three column where the first contain the city, the second a number of suppliers and the third has to contain a number of suppliers of previous three month.

I have used this below:

First Column: FORN_UBICAZIONE_COD

Second Column: Count(FORN_COD)

Third Column: =count({<FORN_DATA_INIZIO={"=$(=MonthStart(AddMonths(Max(FORN_DATA_INIZIO),-3)))"}, >}FORN_COD)

but it doesn't work.

.

Can you help me?

Thanks

[Zhandos_Shotan]

answered here:

Re: Set Analysis previous three month

[JustinDallas]

Can you describe "not working"?  What is it doing/giving to you?  You want the last 3 months, so I assume that you would have a greater than sign somewhere in your set analysis when comparing to the beginning of the 3 months.

Something like this off the top of my head:

count({<FORN_DATA_INIZIO={">=$(=MonthStart(AddMonths(Max(FORN_DATA_INIZIO),-3)))"}, >}FORN_COD)