Crystaluser66
Programmer
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 spring 0
Region NorthWest
edition id edition name entry
131 strjournal 0
132 spring 0
133 City 0
Region South
edition id edition name entry
134 strjournal 10
135 spring 0
136 Cityjournal 30
I am using a running total in a cross tab to show,other details are suppressed except the summary
Region Region Region Region
East West NorthWest South
Edition id
Summary 1 NA 0 2
The summary should be calculated as follows
case 1:if editionname like journal and entry > 0 in a region then count( editionname) in a journal.
case 2 :if editionname not like journal i.e, region doesn't contain any journal then show
NA in summary column
Case 3: if editionname like journal in a region but if entry = 0 then 0
The running total works fine in cases 1(count) and 2(if 0 then in the display string shown as NA) but how to display case 3 in summary
Is it possible to do this.Bear with me for the lengthy xplanation.
any help is appreciated.
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 spring 0
Region NorthWest
edition id edition name entry
131 strjournal 0
132 spring 0
133 City 0
Region South
edition id edition name entry
134 strjournal 10
135 spring 0
136 Cityjournal 30
I am using a running total in a cross tab to show,other details are suppressed except the summary
Region Region Region Region
East West NorthWest South
Edition id
Summary 1 NA 0 2
The summary should be calculated as follows
case 1:if editionname like journal and entry > 0 in a region then count( editionname) in a journal.
case 2 :if editionname not like journal i.e, region doesn't contain any journal then show
NA in summary column
Case 3: if editionname like journal in a region but if entry = 0 then 0
The running total works fine in cases 1(count) and 2(if 0 then in the display string shown as NA) but how to display case 3 in summary
Is it possible to do this.Bear with me for the lengthy xplanation.
any help is appreciated.