Sep 19, 2013 #1 Fsyeda Technical User Jul 19, 2013 18 US IN WEBI 4.0 I need to calculate the sales for last 12 months.(Ex: From Sept 19 2012 till today) This has to be dynamic. I am looking for something like this ; =[Total Sales] Where [Invoice Date] Between (CurrentDate();CurrentDate()-365)
IN WEBI 4.0 I need to calculate the sales for last 12 months.(Ex: From Sept 19 2012 till today) This has to be dynamic. I am looking for something like this ; =[Total Sales] Where [Invoice Date] Between (CurrentDate();CurrentDate()-365)