Analytics Software

Hello all,
A collegue of mine has a little problem. And because we are almost at the end of the project we don't have time to sort this out. So we are using a workaround now. But I really want to know how we can solve this (easialy)

He has made 1 view from the po haeders and po lines table.
So the view contains headers information and lines information together.
Now when he is using this view in answers. Then the info of the headers gets suppressed as soon he is using items from the lines. But this doesn't work on the total_po_header item which is a number.
So when the total of a PO is 1000000 and there are 10 PO lines then 100000 is repeating itself.
Now is the question, how to supress this as well..

The things we tried are as following:
- using the suppressed checkbox in the properties of this item
- cast this item as a character
- using LAST of AVG in the repository as the aggregation type of this item.

None of this work.

So anyone with a simple solution?
We were thinking of splitting the view in 2 views, 1 for the headers and 1 for the lines (this will work I think, but as said before, we don't have time to do this)
Create an extra alias for this object and in one alias you only use header info and in the other alias you only use lines info

We now just repeat every item in the report.