In the above rep i have applied rank on rev by elimating the 0’s and null values in the gaps column.But i need a detail report to show which prod’s has gap for the particular cust.eg:123 cust has 2 gaps so the report should look like:
But its displaying the records which has gap’s O’s and null’s alsoand we are not using the gaps obj in this report.The below is the result i’m getting:
I’m not quite sure what exactly you’re asking, because your own text above states that ‘we are not using the gaps obj in this report’, Yet your asking how to filter on that object?
First to be clear, when you say report, I’m presuming you mean a report, aka an actual tab on a WEBI Document. If you meant report as in a new WEBI document (as business users often confuse the two), then this answer will not make sense and we’re talking about two completely different things.
Assumptions:
You have the gaps objects as an available object within your data provider.
Your report needs to only show records where Gaps <> 0 or Not Null.
Solution is rather simple… FILTERS.
Just open up the filter panel, drag thegaps object in and set the condition.
Hi I have tried your solution but there is another issue which i’m facing at the moment.If user selects top10 then summary report is displaying top 10 records,but the detail report tab should show all the products that has gap for the customer for those top 10 records,but its displaying all the details which are not in the top10 list.I’m not able to figure out what is causing this problem.Any help is much appreciated.
(BOB member since 2007-10-05)