Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I stuck on one bucketing issue that I am not able to tallying last column of report that is Pending SO.
I have created bucket on Shipment date.
Please check
For Past 6 Month
Expression is-
Sum({<SHIP_DT_NUM={">$(=floor(monthstart(vToday),-6)) <=$(=today())"} ,SalesLine_DT={1},Order_Flag={'P'}>}[Pending Order Qty])/100000
Replace today() by vToday variable.
sum({<SHIP_DT_NUM={">$(=floor(monthstart(vToday),-6)) <=$(vToday)"} ,SalesLine_DT={1},Order_Flag={'P'}>}[Pending Order Qty])/100000
Hi Shaila,
I really appreciate your help...
As you said i am showing
Before Dec2016
Dec2016
Jan2017
Feb2017
Mar2017
After Mar2017 as bucket but How can will get old orders? .
Thanks
When I apply your suggested chart then I am getting different values
please share required output.
As per your data your Pending SO is correct (total Pending Order Qty from Jan 1753 to Oct 2017).
and what do you mean by old orders (from MnthYr to MonthYr)?