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 !
total([Your measure goes here] for [AB])
MF.
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 ?