Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
any suggestions
Like this?
Thanks but i need in script side - not on to chart level expression.
Could you please suggest how to do from script side
Hello John,
After creating rolling month calendar. You need to go with left join of calendar with fact table.
Next step is to go for group by with where condition RollingType = R12M.
MidFact:
Load *,KeyDate
resident FactTable;
Left join
Load
KeyDate,
AsofMonth,
RollingType
Calendar table;
FinalFact:
Load
KeyDate,
sum(Measure) as Measure12M
Resident MidFact
where RollingType = R12M
group by *;
Ravi thanks for sharing this info
- unfortunately i didnot received the result
could you please share qvw- apologies
any suggestions pls
suggestions please
Hi John,
see Attachment.
I have used AsOf Table Method.
You see changes in Script Main section.
Regards,
Antonio