BusinessObjects Board

Different Column Results into Rows

general discussion
#1

Hi,

The trouble is it’s creating 2 separate rows where as I just need the one

For Example this is hows its looking

1222
1222873×178 3.79 KB

Thanks

#2

Quick and dirty. Not knowing your datatypes for each object.
I would make the CARALLOWENCEEFFECTIVEDATE a measure, assuming CarAllowance is already a measure. This MAY bring that into a single record for you.

Edit: Welcome to Business Intelligence

#3

thanks for your reply. the object “Salary” and “CarAllowance” 'datatype are measure, “SALARYEFFECTIVEDATE”,“CARALLOWANCEEFFECTIVEDATE” are date. I have already tried your suggestion, but did not work.

#4

Are you able to show us the underlying SQL from your data provider?

I am wondering what the actual data looks like. That would help us determine what is going.

#5

try
max() or first() or last()
on SALARYEFFECTIVEDATE and CARALLOWANCEEFFECTIVEDATE