BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
saitcopuroglu
Community Trekker

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

0 Kudos
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.

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.