Report logic - Show different field values dinamically in one same report column
Content
Hi
Is it possible to make a report that in the same "column" it can show two different column (field) values according with a condition?
My specific requeriment is this: Client incident has columns:
- Product Code
- Product Name (If Product Code = "999", Name = "Other Product")
- Category Code
- Category Name (If Category Code = "999", Name = "Other Category")
- General Description
They want a report Product Code, Product Name, Category Code, Category Name, BUT, if Product Code (or Category Code) = 999, in the "Product Name" (or Category Name) should go the value from "General Description".
Is it possible? How could do the best way to achieve this? I am attaching you an image