I am trying to create a report for a customer that has the following levels of row dimension:
There are several stores, categories, and items in the report
I would like to display only the top 5 Items in the report but not have the system recalculate the totals for the truncated set. I placed a condition that makes a ranking <= 5, but the totals displayed change to total up to the limited returns. Is there a way to make the total lines static, non-changing, so that I can display top 5 but still have the category total? Thanks.