NL Rows - various companies one table

Discussion & Feedback for Jet Pivotier
dmc
Posts: 8
Joined: Thu Jun 21, 2012 6:55 am

NL Rows - various companies one table

Postby dmc » Mon Aug 03, 2015 2:17 pm

Is there a way where I can have multiple companies pulling from one specific table. For example I would like to pull "active groups" from "X table" which is company specific for companies ABC Inc. & DEF Limited
=NL("Rows","X Table","Field","Company=","ABC Inc.|DEF Limited","Active Groups","Filter")

Does anyone have any idea if this is even possible? Thanks!

rmw
Posts: 139
Joined: Fri Jun 26, 2009 5:46 am

Re: NL Rows - various companies one table

Postby rmw » Tue Aug 04, 2015 2:42 pm

Try to use NL(Filter)

E5 =NL("Filter","X Table","Field","Company=","DEF Limited","Active Groups","Filter")
E6 =NL("Filter","X Table","Field","Company=","ABC Inc.","Active Groups","Filter")
E7 =NL("Rows",NP("Union";E5,E6))

HTH

rmw


Return to “How Do I?”

Who is online

Users browsing this forum: No registered users and 1 guest