Hi,
I am currently writting a report in Business Objects (Web Intelligence Document) to reflect Incentives gained by our call centre staff. I have written the report and all the data is correct and it gives me the info i need, however for cosmetics reasons and easy view for managers i need the report to line the row correctly.
For Example:
A customer calls and wants to add legal cover and personal accident cover to their policy mid-term - Holly Daniels (a member of our staff) will do that change for the customer which means she gains 10% of the costing of each product sold..these changes are classed as two events but it is actually only one change. Which means Holly's name appears twice on two different rows and in the legal cover column it says £2.50 in the cell and on a separate row under the personal accident column she has £1.50 in that cell, however the question is, i need both of these showing on one row rather than two with Holly's name only appearing once.
This will work in excel as the formula only represents one cell, however in the Web Intelligence Document one formula represents the whole column.
Is there a formula for this or any advice would be much appreciated.
As Per My below example to read the example properley please click edit above, this will help you understand my situation a bit more as my example is more clear.
Example:
Date Policy Number Customer Name Legal Cover Personal Accident Breakdown Cover Incentive Total
21/10/2008 210000088 Holly Daniels £1.50
21/10/2008 210000088 Holly Daniels £2.50
So the date and the policy number are exactly the same and the events were put in place at exactly the same time in one change, however i need a way of differentiating the two events so that the £2.50 value moves up to the first row and the second row disappears as it's only one change in affect.
Thanks very much for any help!
Kelly
Edited by: Kelly Thompson on Nov 3, 2008 4:35 PM