Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- ColSum Function results to be placed only once per label

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 26, 2015 6:39 AM
(3190 views)

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?

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 26, 2015 6:52 AM
(5205 views)
| Posted in reply to message from saitcopuroglu 02/26/2015 09:39 AM

Try this:

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

Or consider using a summary table for further calculations.

1 REPLY 1

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 26, 2015 6:52 AM
(5206 views)
| Posted in reply to message from saitcopuroglu 02/26/2015 09:39 AM

Try this:

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

Or consider using a summary table for further calculations.