Table Total Causes Blank Rows to Dissapear

[Anonymous]

I have a table with three columns of revenue data in them. Many of the rows have no values for revenue. Click HERE to see an image.

All three revenue values are set to "Don't summarize" so I get no total row at the bottom of the table. If I turn even one of the revenue values from "Don't summarize" to "Sum", I get the total I want at the bottom of the table, but all the blank rows dissapear. Click HERE to see an image.

I need a total at the bottom of the table and I need all the blank rows to stay in the table. Can anyone help?

[Tahreem24 · Accepted solution]

@Anonymous ,

Try to enable the "Show items with no data" option.

[amitchandak]

@Anonymous , once you have a measure. Means a summarized column ( as good as a measure), all grouped data( group by - unsummarized columns) are displayed for its nonblank values. That is causing that.