Range Sum & Above function working wrong when supress zero values option cheked

[#1]

Dear All,

we want to add above sum of rows in pivot table so the expression is written as

if(Region=23, RangeSum(above(TOTAL column(1),1,22)), Data)

it's coming correct when suppress zero values is un-checked for Region = 23 as 158

when we check suppress zero values the result  coming wrong for region = 23 as 256

is it bug or please help if any other solution available.

attached qvw file for your reference.

Region	qty
1	1
2	2
3	-
4	-
5	5
6	6
7	-
8	-
9	-
10	10
11	11
12	12
13	13
14	-
15	-
16	-
17	17
18	18
19	-
20	20
21	21
22	22
23	158
24	24
25	25

Region	qty
1	1
2	2
5	5
6	6
10	10
11	11
12	12
13	13
17	17
18	18
20	20
21	21
22	22
23	256
24	24
25	25

Thanks in advance.

[#2]

Dear All,

sorry,  ignore excel Data wrongly pasted in previous reply and find the excel data below

Region	Data
1	1
2	2
3
4
5	5
6	6
7
8
9
10	10
11	11
12	12
13	13
14
15
16
17	17
18	18
19
20	20
21	21
22	22
23	23
24	24
25	25

[MK_QSL]

Why you want to use Column(1) and not SUM(Data)..

Please explain..

[#4]

i can't use sum (data) model in actual development because the above rows result is coming based on the different big formulas and in that also column(x) is used.

so is there any alternate way to sum above rows using column(1)

any way thanks for your response and if there is no solution its ok and i will try with alternate options.

Thanks ......

[sunny_talwar]

if there is no solution its ok and i will try with alternate options.

Alternative is to use variable my friend, but you seem to be ignoring me and my suggestion

[#6]

sorry forgot to reply you previously. already tried using variable also but not working same problem

[sunny_talwar]

May be share a trimmed down and anonymised version of your dashboard

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[#8]

can you please share personal e-mail ID as am unable to attach any file

[sunny_talwar]

I have added you as a connection. Send me a private message and I will share my email with you.

[Anil_Babu_Samineni]

From Region, Qty What was the expected output?