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

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