Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
You can achieve this by different ways but since you have given the date range, you can use this expression in the KPI -
Sum({<ShipDate={">=07/01/2008<=06/30/2009"}>}OrderQty)
But to make it more dynamic and to make things flexible I would rather create master calendar and add few indicators and fields like Year, Month Year, few indicators like rolling 12 months etc.
Thanks
You can achieve this by different ways but since you have given the date range, you can use this expression in the KPI -
Sum({<ShipDate={">=07/01/2008<=06/30/2009"}>}OrderQty)
But to make it more dynamic and to make things flexible I would rather create master calendar and add few indicators and fields like Year, Month Year, few indicators like rolling 12 months etc.
Thanks
Thank you Vijay Singh for helping me . Much Appreciated your timely help. Cheers!