Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.
Here you go.
Below is the formula which we have used for MTD.
ToDate("Warehouse"."Fact - Sales Order"."Sales Amount"."Warehouse"."Dim - Time"."Month")
Please let me know on how can i create previous Month MTD and Previous Year same Month MTD