Forum Discussion
Removing subtotals from specific columns in tables while still summarizing that field in the table
Hi sbrick,
You can simply turn off the Total Setting from the Format ..
I'm afriad it's not that simple. We DO want the table to have the subtotals but we do NOT want them for those two specific columns. Here is an example:
2 people visit our website, one person looks at just apples and orders an apple for $5 the other person lookst at apples and oranges and then purchases each for $10. At the product level within a category that would be two views for apples and one view for oranges as well as two orders with apples and one order with oranges, which are all correct at the row level.
However, that would then add up in the subtotal to three total visits and three total orders which is not correct since there were only two distinct visitors to the site and two distinct orders.
We do want the category level to show total revenue of $15 because that is correct. But we do NOT want the column to show 3 total visits or 3 total orders because that is not correct and it is misleading/confusing to those viewing the report.
For the record, our website does not sell fruit, it's just an example. :)