Total in a Straight table

bhaskarsharma03 · ‎2013-03-12

Hi,

I have a straight table whose number of rows is decided by a variable as per user input. The expresseion total I am getting now is sum of all the rows present in the table.

What I want is just the sum of the visible rows. If a user wants to see 5 rows, then it should show the sum of the 5 visible rows. Or, if the user makes some selections elsewhere which is restricting the table to show just 3 rows, then the sum should be for just those 3 rows.

Any help will be greately appreciated.

sushil353 · ‎2013-03-12

can u share the sample app.

lironbaram · ‎2013-03-12

in the expressions tab for the expression change the total mode in the middle right side

from expression total to sum of rows

bhaskarsharma03 · ‎2013-03-12

I tried that. It works when the number of rows is limited by some selections made on the application. But doesn't work when the number of rows is determined by user input.

My table gives the details of Top accounts in terms of Sales. And the user can select how many top accounts he wants to see. For example if the user wants to see top 10 accounts, he puts the number in a inputbox, and the table shows just TOP 10 accounts.

What I want is the sum of just these 10 accounts.

lironbaram · ‎2013-03-12

hi look at the attach file

when using dimension limits and som of rows it works

nirav_bhimani · ‎2013-03-12

Hi,

Try this expression in dimension, replace with your dimension column name.

If(AGGR (rank(Count(CID)), DimensionColumnName) <=vTop , DimensionColumnName)

in the above case vTop is variable which take value from Inputbox.

Regards,

Nirav Bhimani

Siva_Sankar · ‎2013-03-12

Check out this.. regards. siva sankar k

bhaskarsharma03 · ‎2013-03-12

It works very well when I have one dimension. How do I make it work if I have multiple dimensions?

Related Topics