Additional subtotal in straight table

[azimabadi]

Hi,

I have a straight  table that i show top 5 (using limits option in "Dimension Limits" in chart's properties and sum of others too.

At the bottom i get the total sum. But i need to demonstrate the data in straight table as follow:

Top 5

---------------------------------------

Sum of top 5

---------------------------------------

Others

---------------------------------------

Total sum

I appreciate any idea.

Best regards - peyman

[er_mohit]

hiii top 5

for sum of top 5

others

total sum

see the attached image

[Gysbert_Wassenaar]

The easiest solution is to use two overlapping straight charts. See attached qvw.

[azimabadi]

Thx mohit,

But i need "others" and total sum too.

This way i loose others.

Best regards-peyman