I have a Cross Tab Report that has 4 summarized columns for columnwise results, out of which only one is desired in the grids. Even though I completely suppressed the remaining 3 results in the grids they occupy some horizontal space.Is there a way to suppress this extra blank space in the Cross...
I have 4 columns and data is like this
customer customer salesrep
account Name code type
4845667343 frank 667 Adjournal1
leone Adjournal2 Detailsa
----------...
At the row level,I am using edition id which could be in multiple regions, row level counts the number of edition ids per region.
and the grand total gives specialized summaries as
Region Region Region Region
East West NorthWest South
Edition id...
OK,I tried directly without using running total as follows
but still got NA
formula {@jrn}
if {table.editionname} like "*journal*" then 1
Rows : Edition id
Column : Region
Summarized fields : Sum of {@jrn}
then Right click at the totals on the bottom of the summary, went to display string...
Hi lbass,
When I use the formula everything is becoming NA.
the summary formula is calculated using running total
as
field to summarize Entry
type of summary count
Evaluate Entry > 0
and editionname like "journal"
Reset
On change of Group Region.
I have my data in this way.
Region East (Group)
edition id edition name entry
123 strjournal 10
124 spring 0
125 Cityjournal 0
Region West
edition id edition name entry
127 citylife 0
129...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.