Page 1 of 1

NL Rows - various companies one table

Posted: Mon Aug 03, 2015 2:17 pm
by dmc
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!

Re: NL Rows - various companies one table

Posted: Tue Aug 04, 2015 2:42 pm
by rmw
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