Forum Discussion

matkvaid's avatar
matkvaid
Icon for Helper III rankHelper III
3 years ago

Is this possible, TOPN as matrix rows?

Hi, i am asked to do something like this - compare table. I have the measures, results are ok, but now i am also asked to make just top product comparing, i would put it in a matrix, but do not find ...
matkvaid's avatar
matkvaid
Icon for Helper III rankHelper III
3 years ago

So if i create calculated table with TOPN, i get what i would like to, but then my calculated table does not recalculate when i apply some filters... 😄 

  • matkvaid's avatar
    matkvaid
    Icon for Helper III rankHelper III
    3 years ago

    Still trying to find something out. If i can create calculated table, add one more columnt that just has value top100 and add to matrix, it works. So maybe it is possible with selectcolumns or something like that? I'm stugling with table functions, sorry for many stupid questions