Only Show Records of Minimum In Object

[jeffreyrdubois]

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!

[anil.ganga1]

I couldn't verify this, but Instead "In" try "For Each" and see?

[CSM07]

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.

[Mark P]

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.