Tricky Reporting Question

[nepatel]

Hello,

I have a table where thousands of records are getting created.

The table has three columns (A, B, C)

When reporting:

• if columns A and B have the same value, show it as one single record;
• if A and B have different values, show them as two different records.

I'm trying to do something without so much data massage and customization.

If you can any help or provde guidelines, it would be great!

TIA!

[Hemanth M1]

Hi @nepatel ,

if your looking for a minimum customization solution try using functional field,

Try concatenate concatenate column A and Column B, Group By functonal field as belolw

FYI: Functional fields are actual fields on the table

Report: 

Hope this helps!!!