Skip to Content
author's profile photo Former Member
Former Member

Webi Report Drill Navigation

Dear All,

I want a solution for the below scenario. Please help.

I have below Objects which defined in custom hierarchy in Univ for Drill.

Region

Country

State

I have a webi Report with Objects,

| Region | Sales Rev |

__________________

|North | 100 |

|South | 200 |

After Enabling Drill. If you Click on "North" It will take you Down "Country" --- Below is the Result

| Country | Sales Rev |

__________________

|US | 60 |

|CAN | 40 |

If you Click on "US" It will take you Down "STATE" --- Below is the Result

| State | Sales Rev |

__________________

|TX | 30 |

|FL | 20 |

Now, I want to define If Sales Rev of "State" < 25 then "Yes" else "No". in another column.

But the column should display "Null" when you are in Top Hierarchy. It should only display "Yes" or "No" when you drill down to "State". Else you get Wrong results which confuses the user.


Below is the expected Result.


Report without Drill

| Region | Sales Rev | Status |

____________________________

|NORTH | 100 | |

|SOUTH | 200 | |



Drill down to "Country"


Report without Drill


| Country | Sales Rev | Status |

________________________

|US | 60 | |

|CAN | 40 | |


Further Drill to "State"



| State | Sales Rev | Status |

__________________________

|TX | 30 | No |

|FL | 20 | Yes |




Please suggest.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 06, 2015 at 06:24 AM

    Try this and check if it works out.

    =If(DrillFilters([State])<>"";IF([SALES REVENUE] < 25;"Yes";"No");"N/A")

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 05, 2015 at 07:31 AM

    Hi Hussain ,

    please refer this once screen shot .Here I applied a drill mode on state it start drill down

    this is working for drill up also when i press on cities it performs drill up mode and

    hope it works

    Thanks &Regards

    Dinesh


    sample.jpg (184.7 kB)
    drill up.png (109.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.