cancel
Showing results for 
Search instead for 
Did you mean: 

How to place Totals in webi after applying break

Former Member
0 Kudos

Hi All,

How to get the total of  all interest receivables ,which is one item from Structure list in webi.Break is applied on Name of the borrower as per the requirement.

This is my Scenario.Below is the screenshot

Thanks in Advance.

Regards,

Sushma

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Sushma,

From what I understand, you have to apply 3 breaks- On the Borrower name, Interest Receivables and Principal Repayment and include totals for the first in the table footer and the other two in the Break footer.

Former Member
0 Kudos

Hi Sarah,

Client requires in this manner.

Please help me out in totals

Regards,

Sushma

Former Member
0 Kudos

Hi Sushme,

Where is the Borrower name?

Former Member
0 Kudos

Hi Sarah ,

In webi its product type .

Regards,

sushma

Former Member
0 Kudos

Hi Sushma,

Apply first break on Product and second on Struct. Uncheck Break headers and footers. Include table header and footer. Insert 2  rows below the footer and use 3 formulas as sum(measure) where [struct]="Interest receivables" and so on. Please let me know if this is not working.

Former Member
0 Kudos

Hi Sushma,

Can you give some more details.

By looking into the structure, it is just adding a footer at the end of break and apply sum of that column to get the total.

But I assume, if you can give more detail to your requirement, it would be better to understand.

Thanks

Gaurav

Former Member
0 Kudos

Hi Gaurav

Please find the attachment ,Please change the extension to .xlsx

this is the requirement which i need to implement in Webi

Applied breaks for Name of the borrower

Thanks in Advance,

Regards,

Sushma.