Subscribe Bookmark RSS Feed

ColSum Function results to be placed only once per label

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

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?

8114_Screen Shot 2015-02-26 at 16.36.37.png

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Try this:

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

Or consider using a summary table for further calculations.

1 REPLY
Solution

Try this:

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

Or consider using a summary table for further calculations.