# Is there a way to have column totals, but only for the top 5 rows?

I have a table with Margin split by Product Type, i would like to show this as a single value visualization, and compare the total margin for the Top 5 to total margin for the rest.

I have tried using the following codes which havenâ€™t worked. If anyone has any ideas/ solutions it would be greatly appreciated

Attempt 1
\${booking_analysis.margin:total}
(this one uses a row limit of 5)

Attempt 2
\${booking_analysis.margin:total}-offset(\${booking_analysis.margin},5)

Hi @clf333,

If I get it right, you have one column, ordering the margin from high to low, and want to compare the sum of the first five margins to the rest in the same column?

I think a table calculation as below would help with the first part.

``````sum(
if(
row()<=5
, \${booking_analysis.margin}
, 0
)
)
``````

This will only sum the values of the first 5 rows, and add 0â€™s for the rest.
You could then have another Table Calculation with

``````\${booking_analysis.margin:total} - \${the_first_calculation}
``````

Donâ€™t forget to hide all other measures if you want to show both table calculations in the Single Value visualisation.

I really hope this helps

Daan

Fantastic! This was exactly what i needed, thanks so much for your help