Need help on creating a variable in WEBi Report

[former_member187092]

Dear Exports,

I am using BO4.1. Have created a WEBi Report in which I have a variable showing a some LOB's as mentioned below,

                                                                                                                                                        Where I need to showcase a chart for this. But I need overall count and have to create "Overall" as like Bank, Creadit card , Depit card is getting displayed.

Please help me creating a logic.

Thanks in Advance,

Bala Krish

[Former Member · Accepted solution]

Bala, Go through this, It may help you

[former_member187092 · Accepted solution]

Hello Sujitha,

You have given the link which is the discussion I started .. But That discussion only helped me..

Thank you!

Regards,

Bala Krish

[former_member418290]

Hi Bala,

In the footer of the table, Under LOB Column give 'Overall' and Under Count Column use sum function and you will get the desired result.

LOB	Count
Bank	46
Credit Card	46
Debit Card	44
Life	46
Overall	182

[Former Member]

Hi bala,

You need to create a variable at universe level,as overall

assigned  table should be LOB object table

and take two queries at report level,merge the objects LOB and overall.

Now convert table into chart..you will get required output.

Regards,

Samatha B

[former_member187092]

Hello Samatha,

I need to do in the report level.

.But I have achieved it using a simple logic...I will post it here soon Once it is completely done.

Regards,

Bala Krish

[arijit_das]

Is there any overlap between LOBs ? If not, a stacked bar chart can satisfy your requirement - where the total length of the bar represents total and individual series length representing individual counts.

[former_member187092]

Hello Arjith,

Thanks for your reply 🙂

I am using trend line chart...But I have achieved it using a simple logic...I will post it here soon Once it is completely done.

Regards,

Bala Krish