Sum of Rows not working

[bhaskarsharma03]

Hi,

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.

Any suggestion how do I show the Sum of Rows?

Regards,

Bhaskar

[Anonymous]

Can you send me the expression used?

[satishkurra]

Hi

In your expression, please write as below

Sum(AGGR (Sum (Sales)), Dimension)

This will solve sum of rows issue

[kiranmanoharrode]

Hello Bhaskar,

Use AGGR Function in your expression

for example productwise  SalesAmount

=Sum(AGGR(SUM SalesAmount),ProductID))

Try this,

It will work.............

Regards,
Kiran Rode

+91 897 697 7897

[anbu1984]

Check this app