Count if match 2 fields in any order

[cbaqir]

I have FIELDA and FIELDB and I concatenate them in the script to be FIELDA_FIELDB. I then do a count to see how many occurrences we have of the matching pair of fields count(FIELDA_FIELDB). However, sometimes the same values could be listed as FIELDB_FIELDA. I want to group them together when the 2 fields are the same, regardless of which order they are in. Is there a way to do that?

[sunny_talwar · Accepted solution]

How do you combine them? May be combine them like this

RangeMaxString(FIELDA, FIELDB) & '_' & RangeMinString(FIELDA, FIELDB) as COMBINED_FIELD

[cbaqir]

I was using FIELDA & '-' & FIELDB as FIELDA_FIELDB

[cbaqir]

Sunny,

When I add the combined field as a dimension, I am still seeing one option for A_B and one for B_A.

What I am after is a way to combine them here. Any ideas?

[swuehl]

Are you really sure you are using Sunny's suggested calculated field and not yours?