Break lines in (Pivot) Table.. How?

[hansdevr]

Hi Everyone,

I need some help with presentation of data from two tables, Dossiers and Claims. A Dossier can hold a number of claims and I want to totalize damages per dossier. The field Recourse is only available at Dossier level. To clear this up, here's a diagram of my tables:

I want to make a list on the screen (which can be exported to Excel) which would look like this:

As you can see, each group of claims is preceded by a single line showing totals for those claims.

What's the best way of achieving this?

Any help would be very welcome!

[Gysbert_Wassenaar · Accepted solution]

Export the basic data to Excel and do the rest in Excel. Qlikview is not a spreadsheet application. Trying to use Qlikview like a spreadsheet is going to be extremely cumbersome.

[hansdevr]

Yes, you're right of course, but there are so many tricks in QV I haven't as yet discovered, that I thought it was worth the while to ask...

Bedankt, Gijsbert!