Hello,

I'm just starting with MDX queries and I hope someone can give me an answer
on (probably) a very simple question:

How do I show the "average store sales" in the data, while showing the
customers on columns and products on the rows?

(I'm using the standard FoodMart sample).

I can't figure out if I should use a calculated dimension or if I should add
it as a new column to the data in Foodmart.mdb before processing it.

Besides this, I would like to be able to make a crossing of two items of the
same dimension, is that possible? I have a questions dimension, containing
all questions of a survey. It would be nice if I could put one question in
the row, and one in the columns, to see the combinations of answers.

If I use something like:
SELECT
{[Product].[Brand Name].[CDR] } ON COLUMNS,
{[Product].[Brand Name].[Plato] } ON ROWS
FROM Sales
it tells me that it cannot create it. Is there perhaps some trick to get
around this?

Any help will be appreciated!

Thanks in advance,
Jeroen