OTBI - Pivot with multiple information types (Email Type, Phone Type)
We have a report with some personal information on it. Among other columns in report we do have Email (incl. Email Type) , Address ( incl. Adress Type) and Phone numbers.
Unfortunatley, whenever there is information type with multiple entries, e.g. address, all columns after this column in report will get duplication of the rows despite the fact that supression is switched on and the values are the same. We had a bit of play in terms of sorting to put these 3 types of info at the end of the report,s till not ideal. In simple terms if switched off supression, in case of dummy employee with 2 address types and 3 email types we will get 6 lines for this dummy employee.