Thanks ,

for the reply, what i did eventuaually was to create a set as advised, then from the set created i was able to create measures for any of the months i choose in the set using their positions item(), then i was able to use the other dimensions (days). so i could compare collections by months by days as well.

WITH

SET

[LASTSIXMONTHS]

AS

(tail(nonempty

( [Dates].[Month Short Name].[Month Short Name].allmembers),6))

MEMBER

MEASURES.LLL

AS

( [LASTSIXMONTHS].ITEM(0),[Measures].[Value])

MEMBER

MEASURES.LLK

AS

( [LASTSIXMONTHS].ITEM(5),[Measures].[Collections])

MEMBER

MEASURES.LLP

AS

( [LASTSIXMONTHS].ITEM(5).NAME)

SELECT

{MEASURES.LLL, MEASURES.LLK,MEASURES.LLP} ON 0,

[Days].[Days].[Days].ALLMEMBERS ON 1

FROM

(SELECT

[Days].[days].&[0]:[Days].[Days].&[60] ON 0

FROM

[ICS])