I need to show number of top deals in a table. Users input the number from a Input box (variable vTopValue). This variable is used in Max Number (presentation tab) to display the user specified number of top deals.
However, even if I set the Total Mode as Sum of Rows, the total still displays expression total. How do I just show the total of the displayed rows?
I also tried to pass the variable in Dimension limits. But that doesn't work either. Seems it doesn't work for a calculated dimension.