jeffmoore64
Programmer
Hi,
This example is using the foodmart2000 sample cube.
What I am trying to do is to simply put an index ie: (1, 2, 3, 4, ..., n) next to the column [drink] in my result set. So my result set would look something like this:
bremerton 1,160.00 1
yakima 1,159.00 2
port orhacrd 1,128.00 3
etc..
The code that generates the first two columns is shown below:
I have tried to use the COUNT function to do this but it keep giving me errors
Tia Jeff
This example is using the foodmart2000 sample cube.
What I am trying to do is to simply put an index ie: (1, 2, 3, 4, ..., n) next to the column [drink] in my result set. So my result set would look something like this:
bremerton 1,160.00 1
yakima 1,159.00 2
port orhacrd 1,128.00 3
etc..
The code that generates the first two columns is shown below:
I have tried to use the COUNT function to do this but it keep giving me errors
Tia Jeff
Code:
select
{ [Product].[All Products].[Drink]} on columns,
subset(
order(
hierarchize(
{
[Customers].[All Customers].[USA].[WA].children
}
), [Product].[All Products].[Drink] ,bdesc
),1
)
on rows
from Sales
where ( [Measures].[Unit Sales] )