Hi there,

I would like to run a query resulting the following table:


Produkt | Jan acc. | Feb acc. | March acc.
--------------------------------------------
Drink | 3.775,36 | 7.413,35 | 11585,80
Food | ... | ... | ...

That was all I was able to come up with so far (Foodmart):

with member [Measures].[Acc. Value] as 'Sum(YTD(),
[Measures].[Store Sales])'
select
Crossjoin({Descendants([Time].[1997],[Time].[Month])},
{[Measures].[Acc. Value]}) on columns,
{[Product].[Product Family].members} on rows
from Sales

which results in the following:
--------------------------------------------
Drink | 3.775,36 | 7.413,35 | 11585,80
Food | ... | ... | ...

How can I avoid the crossjoin on columns? and what do I
have to do to label the columns as in the example above???

Thank you in advance,

Verena

Verena, is this what you mean...?

with member [Measures].[Acc. Value] as
'Sum(YTD(), [Measures].[Store Sales])'
select
Descendants([Time].[1997],[Time].[Month]) on columns,
[Product].[Product Family].members on rows
from Sales
where (Measures.[Acc. Value])

As to labeling, this depends on the front-end -- it is probable you have no
control of this.

public @ the domain below
www.tomchester.net

"verena" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi Tom,
reliable as usual ;-)!!! That's exactly what I meant
thank you.
verena