how to remove the duplicate values on the report 1

[Hm786]

Hi,

I have a report needs to show the following info

lineup chnl# name pack ind

DIG REG-DIGITAL 309 SUNDANCE FAMILY & INFO PKG Y
DIG REG-DIGITAL 309 SUNDANCE FAMILY & INFO PKG Y

DIG REG-DIGITAL 314 HISTORY FAMILY & INFO PKG Y
DIG REG-DIGITAL 314 HISTORY SPANISH PKG PKG N

on my report I want to show only those channels whose ind value is both Y and N. I don't want to show which has both Y's and both N's
Please help me how to proceed with this report

 

[lbass]

Go to report->edit selection formula->GROUP and enter:

distinctcount({table.ind},{table.channel}) = 2

This assumes that you have a group on {table.channel}. Replace the field names with your actual names, of course.

-LB

 

[Hm786]

Thank you it worked like a charm.


Hamida