I need to calculate MTD,YTD and Inception to date(ITD) on the basis of the CycleID concatination with the date range selected in the slicer(filter). The graph should display Total amount by MTD cycleid wise, Total amount by YTD summation of all cycleid amounts for the particular year selected in the slicer from the start of the year till date and Total amount by ITD summation of all cycleid amounts till date seleted in slicer.
Can anyone help me out on this as soon as possible?
Quick response to this question will be much helpful to me as I need to submit the task today itself.
@dhara3010 - Sure, you can use the time "intelligence" functions to do these sorts of things like TOTALMTD or TOTALYTD or you can do it with simple filters. With time "intelligence" functions you will need a separate date table.
The general time "intelligence" way looks something like this: