Skip to Content
0
Former Member
May 26, 2009 at 07:43 PM

Query Building Challenge

12 Views

Hi folks I have a bit of a BEx query building challenge. I'm working off a standard Sales Overview Cube (0SD_C03). I have a calculated key figure which tells me the average contribution margin.

What I want to do is, on 3 seperate lines show how many unique materials for a given time frame have an average contribution margin > than $200, an average contribution margin < $100, and an average contribution margin between those ranges.

It seems like this should be easy but once I get into the guts of it I've discovered it is quite complex.

Has anyone done anything like this before?