Common data values associated with different field

[Anonymous]

Dear All,

I am having two segment Domestic & International and I am having some common Ticket No for both the segment.

Could anybody suggest how to identify those common ticket no?

I tried to solve it using Show Frequency but did not get the success.

Pls suggest.

Regards,

Balraj

[maxgro · Accepted solution]

in a chart with ticket as dimension and count(distinct segment) as expression

[#3]

hii

Try it

Dimension :Ticket

Expression : count (distinct segment)