Help needed

[#1]

Dear All,

I have a problem that I want to calculate the Average Amount of next 3 coming row in a straight table chart but 1 Dimension excluded, on every row like the table

I want to exclude the Dimension Design, SNo. in calculation of RangeAvg

Customer	Design	Machine	SNo.	Sales Amount	sum next  3 rows	Average
A	D-1	Mc-1	1	50	70	35
A	D-1	Mc-1	2	45	25	25
A	D-1	Mc-1	3	25	0	0
A	D-1	Mc-2	4	75	0	0
B	D-5	Mc-1	5	40	25	25
B	D-5	Mc-1	6	25	0	0
B	D-5	Mc-2	7	30	0	0
C	D-1	Mc-1	8	40	0	0
C	D-1	Mc-2	9	30	50	50
C	D-2	Mc-2	10	50	0	0
D	D-1	Mc-1	11	20	0	0

SNo. value of this column is comming from sql query [ Row_Number()  ], it is a running no

Last column is my desired result

I am attaching QVW sample here

thanks & regars

bb

[#2 · Accepted solution]

There is some discrepency in the data above and data in attachment. Anyhow this can be done using rangesum(below (expression),1,3) and rangeavg(below (expression),1,3). Attached the example using your attachment.

Kiran.

[#3]

hi, Kiran

thanks

bb

[#4]

hi, kiran

can I exclude one or two dimensions when calculating rangeavg

thanks & regards

bb

[#5]

Use Total <Dim1,Dim2> after the set analysis in the expression.

Kiran.

[#6]

hi, kiran

thanks for very quick reply,

I am not aware with set analysis can you please describe it

Please tell me "Is there any document related to SET ANALYSIS"

thanks & regards

bb

[#7]

Enclosed the a quick update.

Kiran.

[#8]

Hi, Kiran

thanks again for very quick reply but I found some thing is missing in the sample sanded by you, It the same sample as sanded by you earlier nothing new in it.

Please tell is there any document related to the Set Analysis, if yes then from where I can get it.

Thanks & Regards

bb

[#9]

After checking the document I found that there is not set analysis. So I just updated with total expression.

Kiran