Hi, I have a strange scenario. I have a table chart where I want to show a limited number of rows (depending on a slider object), and then display the sum of the remaining rows just before the grand total. I have used the "Show Other Rows" property along with the "Label for Other Rows" property on the "Presentation" tab of the Table Chart Object.
The result I have is the limited rows are displayed, the Grand totals are displayed, and a line for the "Other Rows is displayed, however, there are no values for the expressions.
I assume you use the Max Number (1-100) option to limit the number of rows you display. The problem with this option is that it only limits the number displayed, but the total for the rows still apply to all rows.
Anyway, go the the expression tab and use the Total mode: Sum of rows option to display the balance.
