I'm using a GroupingCollection with 5 GroupingFields but sometimes my data doesn't have info for one of the GroupingFields. How can I hide that GroupingField when it's null on my data?
This is my GroupingCollection
<mx:GroupingCollection id="gc" source="{reqAnt}">
<mx:grouping>
<mx:Grouping>
<mx:GroupingField name="year" />
<mx:GroupingField name="month" />
<mx:GroupingField name="building" />
<mx:GroupingField name="floor" />
<mx:GroupingField name="room" />
</mx:Grouping>
</mx:grouping>
</mx:GroupingCollection>
and this is an example of my data
2014
January
Building100
Floor1
Room1.1
Room1.2
Floor2
Floor3
Room3.1
Room3.2
In the case of Floor2, I don't want to show the GroupingField "room" because in my data it is null so I want to hide it. But only in the case of Floor2.
Thank you.