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