BEx Query total summarized
I need to fine tune a query.
Basic in structure.
Column is defined as Revenue.
My "Row" definition needs to be summarized.
At issue is the following.
I have dimemsion "Sold to" and dimension "Ship To" defined as objects.
I need Ship To only for the purpose of identifying my Ship To attribute "Country".
Ship To - has display properties as "No Display" and Results Row >> Always Suppress.
Requirement: Results of query to state my Sold To with value.
I have a one "Sold To" to many Ship-To relationship.
I need to have my "Sold To" result listed as a total .... one value,
Currently result separately lists each (hidden - Ship To).
Sold To "A" ...... Ship To USA (NY)
Sold To "A" ...... Ship To USA (NJ)
Sold To "A" ...... Ship To USA (Pa)
Sold To "A" ...... Ship To Canada (Toronto)
Sold To "A" ...... Ship To Canada (Quebec)
I need only two totals .. 1. Country USA and 2. Country Canada.
Not 5 lines as I currently get.
Thank you .... Dan
Edited by: Dan Shemanski on Oct 3, 2008 9:53 PM