Grand Total is Incorrect
438410Jun 13 2008 — edited Jun 27 2008Hi,
I am having some problems using Grand Total on calculated columns (presentation calculations) with a TOP 25 page filter.
I basically have my calculated columns filtered by the Current Week repository variable, and then I want to add a filter to show only the top 25. That all works fine, but the grand total on my report is showing the total of all records, not just the top 25. If I add a normal (non-calculated) column from my subject area, the grand total works fine with the top 25 filter.
Is there any explanation or workaround for this?