Forum Discussion

TCavins's avatar
TCavins
Icon for Helper V rankHelper V
6 years ago
Solved

Table/Matrix Totals and Percent Rows as footer

I have a table and have tried a matrix that has a very basic layout with totals at the bottom.     What I am aiming to accomplish is to have another row that gives percentages of those total...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi TCavins ,

    I just created a sample pbix file about the percentage row, you can get it from this link.

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi TCavins ,

The totals obtains the summary value of each field values in the table. If the field value is in the form of a percentage, the totals will be also presented as a percentage. Otherwise, it will not work. According to your screenshot, it seems that the field values are not in the form of percentage... In this case, you need to rebuild a special table as parry2k said, and the fields in the table should be presented in the form of percentages.

Best Regards

Rena

TCavins's avatar
TCavins
Icon for Helper V rankHelper V
6 years ago

I need the totals row which I have but I also need a new row below the totals with percentages or some other way to show both totals and percentages.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi TCavins ,

    I just created a sample pbix file about the percentage row, you can get it from this link.

    Best Regards

    Rena