Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report logic - Show different field values dinamically in one same report column

edited Jul 21, 2015 8:43PM in Reporting & Analytics for B2C Service 3 comments

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 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!