Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 |
Why you want to use Column(1) and not SUM(Data)..
Please explain..
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 ......
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
sorry forgot to reply you previously. already tried using variable also but not working same problem
May be share a trimmed down and anonymised version of your dashboard
Preparing examples for Upload - Reduction and Data Scrambling
can you please share personal e-mail ID as am unable to attach any file
I have added you as a connection. Send me a private message and I will share my email with you.
From Region, Qty What was the expected output?