ColSum Function results to be placed only once per label<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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?
Re: ColSum Function results to be placed only once per labelTry this:
If( Row() == Col Min( Row(), :Lable ), Col Sum( :Revenue, :Lable ))
Or consider using a summary table for further calculations.
