I have a matrix report with 3 columns (quantity, rate, amount). I want to include a subtotal row, but not show any data in the rate subtotal column since it varies. How can i do that?
Try this article. I used technique 4, cells in cells for a similar type problem. This will also point you to the inscope function that I think will give you what you need: