Skip to Content
Nov 17, 2016 at 06:19 AM

Total No of PO as on that date


Hello All,

I have a requirement, where I need the Count of PO as on that date.

For example ,

Till 14 Nov.-Nov of PO created is 2000, No of PO created on 14th Nov is 0, then on 15th NOv, 5 POs are created, on 16th Nov another 7 PO created.

So I need something like below

Date No of PO Line KF Total No of PO as on date KF

14th Nov 0 2000

15th Nov 5 2005

16th Nov 7 2012.

I already have

No of PO Line KFin my base cube, so only the

total No of PO as on date KF needs to be created

I need it for last 30 days. If this can be done in query please advise,

If in Back end , please provide the code