If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report Studio -AUTOMATIC SUMMARIES - By section value

Started by sanchoniathon, 15 Aug 2013 07:19:08 AM

Previous topic - Next topic

sanchoniathon

Hello to all,

We have this report studio report version 10 that is a "list" with a couple of columns and metrics totals.
It also contains LIST section based on a specific data item that is in fact 2 conctatenated fields.
This is an idea of the way the list looks like:


-----------------------------------------------------------
AB
C--D--E--F--G---H------I------J------K------L------
                                         total  total  total  total

----------------------------------------------------------

Where:
column  [AB]:       Is actually 2 columns (a and B) from the package merged into one single data item and placed in the list header as a "SECTION"
columns [C] to [H]:    Are simple columns from the package
columns and [J]:    Are metrics from the package
column  [K]:      Is a calculation as follows: minus [J]
column  [L]:      Is a percentage as follows: [K] divided by
total:        Are the summaries obtained for each the metrics , [J], [K] and [L] metrics by using the AUTOMATIC SUMMARIES from the SUMMARIZE button

Grouping : Performed on columns C and D

Question: All totals are ok and i have a total for each new value in column [A] and have intentionnally deleted the total lines for each new column .   
   How can i now have a TOTAL for each new section ? I mean based on every new section ( column [Ab] )

Thanks in advance for any valuable feed-back !

MFGF

Meep!

sanchoniathon

Thanks  MFGF i wil try that, but i understand i need to create a new DATA ITEM and place it in the cell (after unblocking it) where i need that calculation because there is no automatic way like cliking buttons to do so ?