Union Queries and display

[gmoorthy]

I have to run a union queries and bring them into a crosstab format.

The query does a
select on basetype,producttype,sourcesystem,dollaramount
where sourcesystem ='A'
and transaction type ='1'
Union
Select on basetype,producttype,sourcesystem,dollaramount
where sourcesystem ='B'
and transaction type = '2'

Now transaction type '1' and '2' have to be put as in one bucket called as common and i want to display as follows

productype ,dollaramount
common (1 &2 )

 

[skrandel]

So, what's your question?

Build this in the query panel. This should be a trivial issue.

Steve Krandel
VERITAS Software

 

[gmoorthy]

I am sorry for the confusion the union query should read as follows -

select on basetype,producttype,sourcesystem,dollaramount
where sourcesystem ='A'
and transaction type ='1'
Union
Select on basetype,producttype1,sourcesystem,dollaramount
where sourcesystem ='B'
and transactiontype1 = '2'

Now transaction type '1' and '2' have to be put as in one bucket called as common and i want to display as follows

type ,dollaramount
common (1 &2 )

 

[skrandel]

If you leave Type out of the displayed data, the amount will be the sum amount accross both dimensions.

Either that or use Grouping within the report.

Steve Krandel
VERITAS Software