Sum based on prompt
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.
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.