Numbers I present on chart should be rolling 12 month figures.
I have cube as a datasouce with regular time dimension where I have month name as a shortname.
Also tried to do separate Month dimension and substring month names from Time dimension.
I considered doing custom rolling 12 month field at Transformer but it needs to be two full years and current so don't know would it be any help.
I have used function:
lastPeriods (12, [Current Month])where Current Month is currentMember('time_dimension')
Any idea how to do this?