Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi!
I need to create one set analysis to summarize values by date. wherein:
SALE_DATE and EXPIRE_DATE.
For each SALE_DATE have EXPIRE_DATE => ex: SALE_DATE (02/01/2013) => EXPIRE_DATE (15/02/2013).
Now I want to summarize sales by month and the same month to summarize the amounts due.
ex:
MONTH/YEAR | SALE | RECEIVABLE |
---|---|---|
01/2013 | 100.000.000 | 120.000.000 |
02/2013 | 150.000.000 | 130.000.000 |
The information will be displayed in a bar graph.
Any idea?
I don't think set analysis is going to help you, but perhaps I don't understand what you want. See attached example.
G Wassenaar thank you.
I need to calculate the days in accounts receivable, which uses the total receivables divided by the average sales of the same period.
DAR = Sum (Receivables) / (Sum (Sales) / 30)
I have only one fact table per invoice.
In the attached file is a sample of the data already summarized by date.
Need to put on red table: Sum (Receivables) and Sum (Sales) / 30, in order to synchronize sales months with the same months of receipt.
I hope I have explained better