Ignore always one selected field selection in expression

[sibideepak]

Hi ,

Here attached the application.

Questions are attached inside the qvw.

[sunny_talwar]

Is attached is what you wanted?

Question 1 Expression: sum(TOTAL <Date> {<Date = >}Value)

Question 2 Expression: Only({<Date = >}Aggr(Rangesum(Above(sum({1}Value)/ sum( {1}Value2),0,NoOfRows())),Date,Desc))

Best,

Sunny

[sibideepak]

Thanks for your answer,

Question is exactly what I want but question 2 I want to rangesum all values disregarding the dimension

here sum is discrete based on date dimension,I want the sum to be continuous 

[sunny_talwar]

Try this expression for your second question:

Rangesum(Above(TOTAL sum({1}Value)/ sum( {1}Value2),0,RowNo(TOTAL)))