how to show totals in a line chart with several dimensions

[#1]

I have a number for service level for each period on the x-axis, for different grouped dimensions (e.g. business line, article type., business unit....).

In the same graph I also want to show the overall service level number for that period, but it doesn´t seem to work. Any suggestions?

thanks in advance

[#2]

How is the overall service level calculated? I think we need some more info on your dataset and expressions. If the overall service level is a sum, then something like this may work:

Sum(TOTAL <Period> ServiceLevel)

That is probably overly simplified, but is the basic idea.

[#3]

The overall service level is not a sum but is simply the total count of orders on time divided by the total count of orders, it is the expression total ( across dimensions like article type etc) in the pivot table

[rwunderlich]

Is service period the first dimension? If so, can you just check partial sums for the service period?

-Rob

[#5]

See the excel attached: the pivot table is a qlikview-excel-dump, the chart is the one it should be, i.e. with a line for the different departments plus a line for the total service level for that week