Forum Discussion

Filippomonti's avatar
Filippomonti
Frequent Visitor
4 years ago
Solved

Combining data in rows

Hi all,   I have this kind of dataset: Table 1: Name  |  Number A         |       1 B         |       2 C         |       3 D         |       4   table 2:  Name  |  Number Aa         |   ...
Need Help
Tutorial Requests
  • Filippomonti's avatar
    Filippomonti
    4 years ago

    Thanks for your reply, I figured out how to solve the problem with a "IF(ISINSCOPE....)) measure

Filippomonti's avatar
Filippomonti
Frequent Visitor
4 years ago

Hi Ryan, 

thanks for the reply.

The problem is that i want to keep the 2 tables divided because there are other datas that i didn't include in the previous example (that was a semplified version).

That said, I'm trying to create a measure that helps me visualize the numbers so I can create an index like measure to sort the matrix.

Hope this helps a little bit.

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

Filippomonti 

do you mean there is no relationship between two tables?

I didn't combine the tables. I just created a new column in table 2.

Could you pls provide more sample data so that I can provide better solution for you?

  • Filippomonti's avatar
    Filippomonti
    Frequent Visitor
    4 years ago

    Thanks for your reply, I figured out how to solve the problem with a "IF(ISINSCOPE....)) measure