Could you please help me asap.
I need to create calculations for MTD and YTD in a report with cube data source.give me the suggestions how to calculate MTD and YTD with cube data source in report studio.
i have a measure STD margin. and fiscal calender dimension.
I want to show that measure value for MTD and YTD
RK
RK,
This video (http://tinyurl.com/29lzxgu) should help you to create a YTD report. This example is not using a cube, however, should give some idea on YTD report creation. Let me know if that helped you.
Thnx, AJVG