Highlighted
saitcopuroglu
Level IV

ColSum Function results to be placed only once per label

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
Highlighted
ms
Super User ms
Super User

Re: ColSum Function results to be placed only once per label

Try this:

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

Or consider using a summary table for further calculations.

View solution in original post

1 REPLY 1
Highlighted
ms
Super User ms
Super User

Re: ColSum Function results to be placed only once per label

Try this:

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

Or consider using a summary table for further calculations.

View solution in original post

Article Labels

    There are no labels assigned to this post.