Consolidate

Jet Reports Historic Posts

July 08, 2015 06:20

None

HI Community,

How to consolidate between 2 tables

Suppose i have Emp and Dept tables
Employee
EmpID, EmpName, Designation
100, Sunil, SE
101, Paul, SSE
102, Chamber, CEO

Dept
EmpID, Dept, Sal
100, IT, 20000
102, HR, 15000
104, Acc, 22000
105, SAP, 1500

How to consolidate 2 tables with EmpID.

Please anyone help me.

Date Votes

1 comment

0

Jet Reports Historic Posts July 08, 2015 07:09

In cell D4: =NL("Filter","Employee","EmpID")
In cell D5: =NL("Filter","Dept","EmpID")
In cell D6: =NL("Rows",NP("Union",D4,D5))

HTH

rmw

Comment actions Permalink

Please sign in to leave a comment.