Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need Total of a Measure Constantly without aggregation

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 NameNo. DeliveriesTotal Deliveries
A143
B243
C243
D443
E343
F643
G043
H843
I643
J543
K343
L243
M143
N043

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 NameNo. DeliveriesTotal Deliveries
A137
B237
C237
D437
E337
F637
G037
H837
I637
J537

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

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question