Simple Question using Avg Function

[scunha]

I have a cube with 8 dimensions: time, organization, customer, item, region, market, salesperson, shipped_from

3 Measures: invoice_qty, invoice_price, sales_total

I want to get the average invoice_price for an item ...across any dimension or groups of dimensions... what is the proper syntax for creating a calculated member using the dims and measures above

Thanks in advance
Steve

[Island1]

The good news is that this has been covered in detail at:

http://databasejournal.com/features/...le.php/3404601

Please get back with specific questions after you give it a quick read. And if you intend upon writing MDX with any regularity, please review the series on occasion. I expect to be here for a while ...

Good Luck,

Bill