Forum Discussion

KHolmstrom's avatar
KHolmstrom
Frequent Visitor
4 years ago

Matrix without Row Totals shows wrong values

I want to report a bug.

When I visualize my data in a Matrix and turn off the Row Subtotals (and keep the Column Subtotals on) the data gets shifted

 

 

7 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    Hi, KHolmstrom ,

    I tested it and it working correct.

    can you share the file after removing the sensitive information?


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • KHolmstrom's avatar
    KHolmstrom
    Frequent Visitor

    Hi,

    I checked again and realized that I had added Date (Year+Month) to both Rows and Columns. When I removed the Date from the Rows it works as expected.

     

    If you still want I could send you a file, but with this information (attached snapshot) I believe you should be able to recreate the table/problem

     

     

    I realize this is probably not a table setup that is extremely common – but still possible I believe. I see no logics in the numbers being shifted – so I would still consider it a bug.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    Hi, KHolmstrom ;

    I tested it angin. and ok.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • KHolmstrom's avatar
    KHolmstrom
    Frequent Visitor

    Sorry, I don't know how to share my files in a proper way?
    I tried to open my Matrix in "Show as Table" (see below) - and then the table shows up correctly (but with totals)

     

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support

    Hi, KHolmstrom ,

    Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • KHolmstrom's avatar
      KHolmstrom
      Frequent Visitor

      Hi,
      I don't have a problem, I reported what I believe is a bug - and I still believe it is a bug (even if it is only a problem if you add Dates to both Columns and Rows),

      ...and since nothing has changed there is no solution to accept.

      But from my side it is ok to close the issue.

      BR//Kristina