Forum Discussion

Lodoardi's avatar
Lodoardi
Frequent Visitor
10 years ago
Solved

Matrix - The Total is ignoring the columns

Hi everybody, I have a matrix with two fields in "Columns", but in the "Total" column I just see the final big total, and not the total for each value in the columns. As shown in the picture,...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi Lodoardi,

     

    In the Matrix visual, Total Column is returning total for the outmost layer column group instance, so what you get is expected.

     

     

    Currently, the matrix doesn't support custom total values. In your scenario, to work around the issue, you can create another matrix, place the field contains %Full and %Out, and Year-Semester in Rows, and value field in Values.

     

     

     

    Best Regards,
    Qiuyun Yu

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

OK, trying to wrap my head around this. Are you saying that you want the total "% Full" and Total "% Out" at the end of the row so that you know what total % was Full vs. Outlet, or do you want to know the Amount of Full vs. Outlet in $$?

Lodoardi's avatar
Lodoardi
Frequent Visitor
10 years ago

I want these three columns on the right end: "Total % Full Price", "Total % Outlet" (as you said) and finally "Total" (The only column that I already have).

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    10 years ago

    Hi Lodoardi,

     

    In the Matrix visual, Total Column is returning total for the outmost layer column group instance, so what you get is expected.

     

     

    Currently, the matrix doesn't support custom total values. In your scenario, to work around the issue, you can create another matrix, place the field contains %Full and %Out, and Year-Semester in Rows, and value field in Values.

     

     

     

    Best Regards,
    Qiuyun Yu