Jump to content
Changes to the Jaspersoft community edition download ×

Aggregation question


hello_13

Recommended Posts

Hi,

I am trying to do a report on contracted revenue per customer per month, but the structure of my data is making life very difficult.

I have a Contract Header that has the number of People. This has a 1:N relationship with Contract Lines that each have a Product. This has a 1:N relationship with Contract Line items have the Amount and the Month.

So I have Month as the column header, and as a measure I need to work out Amount per person which I can't seem to do. I can get the correct Amount and People as measures, but if I try dividing one by the other the lines are just blank. I assume that the problem is with setting the aggregate level or the summary calculation but I'm not sure what they should be.

I just need total Amount / total People, whichever way is easiest!

Thanks in advance,

Robin

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...