Search for answers here or ask a question

Combining two discovery tables in present


We have two tables which we are trying to merge.

The left one defines top 20 suppliers with their market share in cur month, previous month, cur ytd, current ytd.

The right one gives us the sales change % between cur and previous month and between current and previous ytd.

We would like to add the two columns from the right table to the left one, in a way that vlookup would deal with it in excel.

The reason that we could not combine them in the original discovery is that change % calculation would calculate the % change in market share in this way, but not the sales.

Any ideas?

Many thanks

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Avi PerezAdmin
    • "making the sophisticated simple"
    • AviPerez
    • 3 mths ago
    • Reported - view

    Not currently possible. New capabilities in the next major release address this.

Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 1Replies
  • 20Views
  • 2 Following