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

Values are good, I wrote the measure to give me a different total (you can see that the sum of full price and outlet is aalways 100 even if the total is different). What I want is to have the last bold column called "Total" divided (like the others) by Full Price and Outlet, and finally the Total of everything. Insted I just have the Total of everything.
In the following image (I found it in the web) There is part of this kind of total I'm describing.

 Tanks.

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