ColSum Function results to be placed only once per label

Question

I have a calculation formula in Calculations column as:

Col Sum( :Revenue, :Lable )

The calculation is displayed as calculations, however, is there an oppurtunity to display the result only in the first row of each label (as displayed by the desired column) and the rest rows to be handled as missing data, which helps a lot for further calculations?

ms · Accepted Answer

Try this:

If( Row() == Col Min( Row(), :Lable ), Col Sum( :Revenue, :Lable ))

Or consider using a summary table for further calculations.