UNION IN BIP Report

Hi,

I have a requirement to sum one particular column. The query is as below.

When i run BIP(Oracle BI Publisher 11.1.1.9.0 ) report I'm not getting SUM(ESTIMATE) and it comes as blank value. This is happening only with UNION query. Without UNION query the result is displaying SUM(ESTIMATE).

The Output should be as below :

MODEL COUNT SUM(ESTIMATE)

OPTIMA 4 199.13

RIO 53 6605.44

SORENTO 119 15258.7

Can someone suggest any issue/limitation with BIP report in displaying with UNION query.

SELECT SUBSTR(MODEL,1,3),COUNT(*),SUM(ESTIMATE) FROM SIEBEL.CX_MPG_CLAIM A WHERE ((A.CLAIM_DT - 7/24) >= TRUNC(SYSDATE - 60) AND (A.CLAIM_DT - 7/24) < TRUNC(SYSDATE)) and model like 'RIO%' GROUP BY SUBSTR(MODEL,1,3)