Author |
Message |
jeffreyrdubois Forum Member


Joined: 05 Jul 2018
Posts: 12

|
Posted: Fri Nov 30, 2018 8:55 am Post subject: Only Show Records of Minimum In Object |
|
|
I have the data similar to the following that I am pulling into WEBI
Inside each "Group" Denoted by 'Group Number' are at least 1 item. The item with the lowest number is the primary item for that group.
I want to create a stacked bar chart showing how many "A's" and "B's" there are, but I only want to display those that are Primary Items (Lowest Item Number in Group Number)
I tried to create two objects
Primary Item
=Min([Item Number]) In ([Group Number])
Primary Item Indicator
=If([Item Number]=[Primary Item] ; "Y" ; "N")
And then my plan was to filter my stacked bar chart (which currently displays every item) by "Primary Item Indicator = 'Y' "
But when I do this all I get is an empty bar chart.
What am I doing wrong?
Thanks! |
|
Back to top |
|
 |
anil.ganga1 Principal Member


Joined: 04 Jul 2007
            Posts: 477 Location: San Francisco

|
Posted: Thu Dec 06, 2018 4:56 pm Post subject: Re: Only Show Records of Minimum In Object |
|
|
I couldn't verify this, but Instead "In" try "For Each" and see? _________________ Thanks,
Anil.
Business Objects 6.5/XIR2/3.X/4.X
Crystal Reports 9/XI/XIR2/XIR2A/2008/2011/2013/2016 |
|
Back to top |
|
 |
CSM07 Forum Member


Joined: 15 Nov 2016
   Posts: 12

|
Posted: Mon Dec 10, 2018 2:49 am Post subject: Re: Only Show Records of Minimum In Object |
|
|
How exactly are you filtering it?Are you selecting it or entering it manually?If your object 'Primary Item Indicator' is a measure then convert it into a dimension object. |
|
Back to top |
|
 |
Mark P Forum Devotee


Joined: 03 Feb 2003
                 Posts: 11274 Location: Manchester, UK

|
Posted: Mon Dec 10, 2018 9:57 am Post subject: Re: Only Show Records of Minimum In Object |
|
|
1. Create a copy variable of Item Number as a Measure.
2. Now use the ranking functionality to rank within Group on Item Number Measure (or whatever you called your variable in step 1) and keep the bottom 1. _________________ Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS
______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996! |
|
Back to top |
|
 |
|