Values are not tallying

[Anonymous]

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

[tyagishaila · Accepted solution]

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

[Anonymous]

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

[Anonymous]

When I apply your suggested chart then I am getting different values

[tyagishaila]

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)?