Two records after adding Proj type
I have an below webi output based on two sources. SAP and Oracle
Case 1 output:
ordnum(merged dimen of SAP and Ora) plant (merged dimen) profictr (merged dimen) Amt1 Amt2 Am1-Amt2
342 XXXX 792 238482 200 238282
Case 2 Issue: Adding Proj type into the Case 1 output
ordnum(merged dimen of SAP and Ora) plant (merged dimen) profictr (merged dimen) Amt1 Amt2 Am1-Amt2 Proj type
|342||XXXX||792||200 200 Projects|
342 XXXX 792 238482 238482 Project
From Case 2 output, i just added proj type dimension into case 1 and the amount is splitted up into two records.
Now what iam trying is endoutput should be case 2 should have one records only as like case 1 having Proj type as additional column. Both Projects and project is of type Projects proj type.
Appreciate your help.