Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need a report in that form:
W1 | W2 | Wn | |||||||||
GLOBAL | GLOBAL | GLOBAL | sum(Invoices) | sum(receipts) | sum(invoices due) | sum(Invoices) | sum(receipts) | sum(invoices due) | sum(Invoices) | sum(receipts) | sum(invoices due) |
I have date of invoices and week dimension create over that, and term of pay so i can find due date.
how to fit the due date if it is in another week?
Hey
Please clarify your issue....
Date of invoice (dataInv) : 01.02.2012 - week(DataInv) = 5, value = 100
Due date (Ddate) : 15.02.2012 - week(DataInv) = 7
Pay date : 20.02.2012 - week(DataInv) = 8
In that case i should have:
5 | 6 | 7 | 8 | ||||||||
100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 0 | 100 | 0 |