Need Total of a Measure Constantly without aggregation

[Former Member]

Hallo Experts,

I Need to show Total of a Measure Constantly without aggregation in Webi in one column.

The requirement is to show following

Supplier Name	No. Deliveries	Total Deliveries
A	1	43
B	2	43
C	2	43
D	4	43
E	3	43
F	6	43
G	0	43
H	8	43
I	6	43
J	5	43
K	3	43
L	2	43
M	1	43
N	0	43

I am using following formula" =sum(No. Deliveries) In (Supplier Name)

(I have used Forall and foreach functions also but they are splitting per supplier)

It is delivering values correctly.

But when we do ranking for top ten suppliers, it showing total for only for those ten suppliers. Like below

Supplier Name	No. Deliveries	Total Deliveries
A	1	37
B	2	37
C	2	37
D	4	37
E	3	37
F	6	37
G	0	37
H	8	37
I	6	37
J	5	37

But the requirement is to show Total deliveries for all suppliers no matter how many suppliers we show.

Please provide me with any suggestions.

Thanks in Advance

Indra

[former_member190895 · Accepted solution]

Use sum(No. Deliveries) In Block

[Former Member]

Solved it with "=nofilter(Sum(No.Deliveries) in (Supplier Name))

Thanks