Skip to Content

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

Sum based on prompt

Hello All,

I have a report(requirement) where i need to display total for data based on the inputs in selection prompt. More details in the attachment.

for Prompt RSo : if i select 1 value ex: APP then it should display totals for Data for APP.

and when I select 2 values for promptĀ  APP and BWPO . The report should display totals for App in one section and in 2nd section for BWPO and Totals for both APP and BWPO.

Also, If there is single entry then there will be single block, and the number of report blocks increase with as many values as in prompt selection.

The first 2 images are from cognos, 3 image is from webi i need to create

How can I accomplish this?

Any inputs highly appreciated.

Thanks.

Former Member replied

Hi Pali,

Sum and percentage that you are seeing in attached screenshot(highlighted in red) is overall percentage and sum for both APP and BWPO Rso.

If you want to see percentage for each individual RSOs create one new row below Sum row of each RSO and write formula for the percentage.

It will show you percentage for each RSO.

~Anuj

0 View this answer in context

Helpful Answer

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