Forum Discussion

dmoney7612's avatar
dmoney7612
Helper II
5 years ago

Matrix exporting question

When I export the data from the below matrix to Excel, the rankings all appear as "1" in the file. Is there a way to work around this issue? I noticed this isn't a problem when exporting from the table visual, but it doesn't seem to like the row drill down format I'm using with the matrix. Here is my ranking formula for reference...thanks in advance!

 

 

 

 

Need Help

11 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    dmoney7612 How are you exporting, from the Desktop export to CSV file or in the Service? I tried replicating this but was not able to do so in the Desktop.

    • dmoney7612's avatar
      dmoney7612
      Helper II
      5 years ago

      Greg_Deckler Yes, desktop to CSV. I'm thinking it's an issue with the matrix format. Rankings appear fine when I export a table visual. 

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        5 years ago

        dmoney7612 Hmm, what version of the Desktop are you on? I can upload my test version if you think it might help.