Wants the totals to show the sum of only those rows which has been displayed instead of sum all the rows in a straight table!

[#1]

Hi

In a straight table I am restricting number of rows to be displayed in the chart by passing a variable in the Properties --> Presentation --> Next to: Max Number(1-100)--> vRow, where vRow is a variable!

But the total which has been displayed using Properties --> Presentation --> Totals is giving the total all the records. I want the total to calculate the total of only those rows which has been displayed instead of all the rows.

Could you please help me out on this!

[#2]

Hi

Imagine if 100 of rows are data are there in the straight table. I am restricting the Number of rows of data to be displayed as 10 using the variable vRow. But the total is showing the sum of all the 100 rows. What I need is total should show only the sum of 10 rows not all the 100 rows.

Hope it is understandable now!

[#3]

Hi

Looks like nobody has understood what I need! So have attached the sample application to your understanding. Hope some one can help me out on this.

[kji]

set your expression to:

if(RowNo()<=vRow,Sum(Column2),NULL)

and change the Total mode to Sum of Rows.

[pat_agen]

Hi,

a sum with an if clause would do what you require. check the qvw.

[jonathandienst]

Hi

Have you tried changing the total mode from Expression Total to Sum of Rows?

Jonathan

[#7]

Hi Jonathan I have already did that but it is still the same! 😞

[#8]

Hi Johan

It works with the sample file which I have given. But in my real application expression is like below and it doesn't work with that. I don't know what to changes are required in that. Can you please check it once!

Sum({<[Week] = {'$(vSelectedWeek)'}>} [$(vCurrent)])