Row ID for DataSet

[justins57]

Does anyone know an easy way to include the Row Number in the dataset results? I am hoping to get something like this:

Row Store Sales
1 NE #11 10,000
2 SE #3 200
3 WC #22 5,000

Thanks,

Justin

 

[MDXer]

Since OLAP DataSets are aggregations of the underlying rows they rely don't have a rowID. if you need some numeric value to act as a row ID then you could use a rank function.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[justins57]

I tried the Rank function, but it doesn't do what I needed. I ended up adding a Row column to my grid.

Thanks for feedback.