PowerView for Sharepoint 2013 , No Column Totals in Matrix Report!


  • Hi,

    I am using PowerView in sharepoint 2013 "SSRS Sharepoint mode, when I create  Matrix report I dont get column total, even though it is selected from matrix option.

    I found this happens when I use in the matrix a field that is sorted by another column "in the PowerPivot model", 

    But when when I build the exact same report in in PowerView for Excel 2013 I get the column totals normally

    please check the image below which shows what i get from Sharepoint an what I get from Excel, the missing totals should be where i draw the rectangle 

    Any Idea?



    Monday, September 9, 2013 1:54 PM

All replies

  • Hi Saleh, I am facing exactly the same issue. Wondered if you have it resolved. This must be a bug with Sharepoint 2013 Powerview!
    Thursday, August 7, 2014 11:22 PM
  • Even I have faced similar issue recently - might be a bug.

    Interesting thing here is, when I tried to sort the data in matrix based on Total Column (With Both Rows and Columns turned ON), I observed that the data did get sorted correctly based on Totals. So, the issue seems to be just with the display of numbers in Totals columns.

    I am trying to figure out if there is any alternative to resolve this issue. Will post it here if I come across any.


    Wednesday, July 15, 2015 12:30 PM