Hi

I have a situation where I want to have three alternate attributehierachies in one dimension.

Lets assume this scenario

Dimension FruitAndVegetables (with 4 columns: Id, Name, Fruit and Vegetable)

Id Name     Fruit      Vegetable

1 Apple      Apple   

2 Onion                   Onion

3 Banana   Banana

4 etc

Now I would like to put Vegetable on rows in a report without getting a blank row (with the sales of all Fruits)
I would like to supress all those Fruit records without adding  a separate filter to the report, just let the user pick this Attibute should do the move.

Anyone that have a clue ?

// Jocke