Created revenue for a specific fiscal month

[Anonymous]

Hi all,

I have a question which is kind of hard to explain, but I'll try.

Every day we create orders in our ordersystem. The revenue of this sales will be taken in the month the orders are invoiced. So, we create an order today (Nov-2012), but the revenue is in Dec-2012. We would like to see the created amount of revenue on each day. When doing so we are able to see how much revenue we created in on a specific day in Nov., for the month Nov., Dec., etc.

Let's give me an example (also in QVW file in attachment):

We want to create a line graph which shows me the booked amount of sales in a specific month. That will look like this:

Can someone help me to create something like this? The example is very simple, we would like to make this for a few years of data.

[MayilVahanan]

Hi

Are you expecting something attached file?

[#3]

Hi,

just create a new pivot table, add "Createdate" as first Dimension and create a new Dynamic Dimension:

= MONTH(Invoicedate)

Then add a new expression:

SUM (Amount)

Shoulkd look like this: