Missing subtotal in columns

[nironixon]

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

[v-huizhn-msft]

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

[Anonymous]

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.