Nested cross tab and head function

[petterhuseby]

Hi


I have a nested crosstab and want to show just the first member(head) in the lowest colum row. If you look at the picture I got tree dimmension in the header row. the first line is different horse track, the second is the race date and the last row is the race place. I want to create see how many time a horse win, first time on a new track, so I nee to only se the first member. like 5 under bjerke travbane and 4 under bodø travbane.

Any tips on writing a good mdx fuction for this, to I can drop an data item in my cross tab and it only show the first member.

Thanks :-)

Petter