Different Level data in 1 Column

building reports webintelligence
1

Hi Gurus,

I’ve a scenario and i want to do it in Webi Report.

The scenario is:

I’ve 3 different levels of Account no’s.

I’ve to create a Column where all the 3 different levels has to appear in one column as per conditions. The conditions are,

  1. If there is no subtotal in the Row then it is Level 3 Account no.
  2. If there is Level 2 Subtotal in the row then the account no. is level 2 account no.
  3. If there is level 1 Subtotal in the row then the account no. is Level 1 account no.

Can any one please suggest me a way?? :hb:

If you need more information, please let me know.

Thanks a ton in advance.

Regards,
Ravi Kanth

ravikanthbn :singapore: (BOB member since 2009-04-16)

2

Use IF Else funtion…

Or let us know more details…

amitrathi1234 :india: (BOB member since 2007-10-15)

3

If else function can work but i need to know that the data in the row is related to Level 3 or Level 2 or level 1 account data. How could i know this?

Can you please suggest me a way?

Please.

ravikanthbn :singapore: (BOB member since 2009-04-16)

4

In your report there is any flag or any dimension objects by which you can know?

amitrathi1234 :india: (BOB member since 2007-10-15)