Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Sub totalling Columns in a view

I am trying to get a view to sub total a selction which is text and not sure how I can set this up. I have graphically tried to describe what I need to do below. Not sure how to count when it is a text value. I want the same as the Count function in Excel.

Value 1
       Option A
       Option A
       Option A
       Option B
       Option B

Value 1
       Option A  
               3
       Option B  
               2
       
0
jforget1
Asked:
jforget1
  • 3
  • 2
1 Solution
 
jforget1Author Commented:
Just to clarify

This is the standard view
Value 1
       Option A
       Option A
       Option A
       Option B
       Option B

This is what I want it to look like, counting the Option A and Option B selections
Value 1
       Option A  
               3
       Option B  
               2
       
0
 
SysExpertCommented:
Have you tried using the subtotal option in the columns options ?

WHat is happening when you try ?

I hope this helps !
0
 
shuboarderCommented:
I'd categorise the option column.....

Then....

Put a column in front of this and give it the formula of 1.
On this column goto the properties, second tab
Select Totals and put a tick in hide detail rows.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
jforget1Author Commented:
THis is definitely the right track, just one detail I am hoping can be fixed.

Below is a copy of the data in the view. the entries are showing hidden below the option, in this case New Hardware. I have a twistie for this item, is there a way to have the view collapse the individual entries by default?

      Office            Stock
      716      1      
              1      New Hardware
      718      1      
              1      New Hardware
0
 
jforget1Author Commented:
Any ideas why this type of view setup would not work in a Send Newsletter Summary Agent? I am only getting a doclink and the number 1 I entered as the value for that column above. Can a categorized view be used in a Newsletter?
0
 
shuboarderCommented:
Under view properties >> second tab >> Put a tick in collapse all when database is first opened.

From above it looks like you might also want to categorise the third column as well.

Hope this helps!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now