Skip to Content
0

How to get most occuring value from second query?

Nov 29, 2017 at 06:52 PM

30

avatar image
Former Member

Hello,

I have two queries resulting in two tables.

  • Columns table 1: Item Number
  • Columns table 2: Item Number, Order Number, Supplier

Objective: add a second column to table 1 which displays the most used supplier for the item number in that row.

What I have done:

  • I have merged the 'Item Number' variable
  • I created a custom variable (see below).
=Mode([Supplier]) In ([Item Number])

This variable gives me the most used supplier for *all* item numbers. I however want the most used supplier for only the item number in that row.

I am clueless on how to achieve this. Can anyone provide me some help?

10 |10000 characters needed characters left characters exceeded

Corrected the tag and can you share the sample data please.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers