In the attached Qlikview file I have a graph which displays revenue over time.
The months are based on the Close Date for the opportunity, the bars represent expected revenue.
What I need is that the revenue is divided over the months. The full revenue is now plotted on the month of the Close Date but ofcourse if this revenue is earned over 5 months this amount needs to be divided over all the months.
The field which says the number of months in the opportunity is below the graph (new_assignmentduration). How can I divide the revenue for each opportunity over the number of months for that opportunity starting at the close date?
