Forum Discussion

Helper V

8 years ago

Need Help

I have Organization Names as well as Job Numbers. Each Organization generally has multiple jobs. I need to show Organizations that do not have MRB jobs. I have a column that classifies a JOB as "MR...

Need Help

mehaboob557

Resolver III

8 years ago

Hi bhmiller89,

First i want to know the whether all the values you are trying are in one table or in multiple tables.

But, my idea is to add the column which clasifies a JOB as "MRB" or "NOT MRB" in the visual filter(if you want to show in particular visual) or page filter(if you want to show in whole page level) and click on check box which have MRB JOBS in the filter.

Hope this helped you. Please give a kudo and accept solution if it worked for you.

bhmiller89

Helper V

8 years ago

mehaboob557

I need to classify the Organization as MRB or NotMRB and each organization name has multiple jobs, some of which are MRB and some of whcih are Not MRB.

So for example I can have ClientX that has job 1 which is MRB and job 2 which is Not MRB but I need to tell BI that ClientX is an MRB client because at least one job is MRB.