Forum Discussion

MasterSonic's avatar
MasterSonic
Helper IV
4 years ago

2 Tables _ Combine _ RANKX

Hi guys,

I have a quick question, maybe you can help.

Table 1

Code PlanGroup Arrival dateother column
1CCC/aWindows 1/1/2020 
2CCC/aWindows 1/1/2020 
3CCC/aLock1/1/2020 
101CCC/a Lock1/1/2010 
203CCC/b Door2/1/2010 
205CCC/b Door2/1/2010 
206CCC/b Door2/1/2010 
205rBBB/a 2/1/2010 


Table 2

PlanGroupClassSold Date
CCC/a WindowsHard1/1/2000
CCC/a LockMedium1/1/2005
CCC/b DoorMedium20/04/2020

 

What I can do is to create table visual like this

 

CodeClassSold DatePlan
203Medium 20/04/2020 CCC/b
205Medium 20/04/2020 CCC/b
206Medium 20/04/2020 CCC/b

 

What I would like to do is to do this:

CodeClassSold DatePlan
1Hard 1/1/2000 CCC/a
2Hard 1/1/2000 CCC/a
3Medium 1/1/2005 CCC/a
101Medium 1/1/2005 CCC/a

 

Could you help me with that please ? 

Plan is calculated column with Rankx.

Merge
RANKX
VLOOKUP

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi MasterSonic ,

     

    Have trouble to follow.

    Please explain the logic about the calculation.

     

    Best Regards,

    Jay

    • MasterSonic's avatar
      MasterSonic
      Helper IV
      4 years ago

      Hi Jay, confusing post. Sorry for that.

      I have amended one thing in my question too.

       

      Tables are linked with Plan columns.

       

      If I drag code field (203,205,206) into to the table chart, it displays correctly class and sold date.

       

      But for 1,2,3,101 who belong to Plan CCC/a (table1), we have duplicated CCC/a value in table2.

       

      My visual duplicates 1,2,3,101 for values from table2.

       

      Eg. Sold date will be printed for all of these 1/1/2000 and again 1/1/2005. 

       

      Where it should be as a wanted results table as a shown.

       

       

       I would like group from table1 works as an extra reference with Code

       

      Is it possible?