Forum Discussion

nironixon's avatar
nironixon
Frequent Visitor
8 years ago

Missing subtotal in columns

Hi, 

I have a problem which I dont undertand. I have created a Matrix in a report and expected 

that a subtotal should be available for ALL columns in the matrix. If you have a look on my screendump you can see that 

for dates 2017-01-01 and 2017-01-02 the subtotal is missing. On the last column, 2017-01-03, the subtotal is correctly displaying. I need subtotals for all columns.

 

 

 

Any clue why my report behaves like this?

Best regards Niclas

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    How does the RevenueSharing Measure looks like...

    I think you are trying to sum up the Text values in which it fails in 2 of your cases but works in one of your case as it as has one and only one value where the sum operation doesn't kicks in, though I am not pretty sure.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi nironixon,

    Have you resolved your issue? If you have, please mark the right/helpful reply as answer. More people will learn new things here.  If you haven't, please feel free to ask.

    Best Regards,
    Angelia