Skip to Content
avatar image
Former Member

How to get most occuring value from second query?

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers