Total in a Regular Table
SummaryTotal in a Regular Table but exclude the measure column
I have a regular table which is set up with the Total After on the Table Columns and Measures (see below screen shot 1). I have no issue with any attribute columns since I can turn on/off the total using the Total button beside the column name. There is a measure column which I don't want it to be totaled but it does due to the Table Columns and Measures set up. (see below screen shot 2). How could I make remove the total for the measure column?
There is no Total button beside the measure column and the Aggregation Rule - None doesn't work. When I set it up as None, no value will show up in the column. The one I'd like to count is the requisition ID so that we know how many requisition we have on the report. It's not a number field and SUM cannot be used.