Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have two dimensions in my report (pivot or straight) displaying start date & end date. Now i want to display all the dates between start date & end date.
You'll need to create a Calendar and use the intevalmatch function (see below for an example)
Calendar:
LOAD
Date('01/01/2011' + RowNo() - 1) AS Date
AUTOGENERATE 3000;
Transactions:
load * Inline [StartDate,EndDate
01/01/2012,01/06/2012
];
Inner Join IntervalMatch (Date) LOAD
StartDate, EndDate
RESIDENT Transactions;
Xooooooooooooow, Tanks msheraton
Please can you mark my post as correct, thanks