Indicator non aggregate

Hi everybody,

I'm working on SQL Server 2005 & Reporting services to create a Projet model to deploy it on the server.

To explain me, i 'll recreate simply my problem on the the database "AdventureWorksDW".

I woudl like to see information on my product dimension.

In a matrix tab, i put "Product name" in row value and "customer name" on column.

I would naturally know the "Sales Amount" for my product by customers.

But, as i had not create aggregate, i can't put my numerique value on the cells indicators. It just allowed me to put the SUM(SALES_AMOUNT) by exemple, but it's not what i want.

How can i put my numerique value in this case ?

Regards,

Erwan

Toulouse, France

Have a column called count on the fact table.

Have the value 1 in the column

Sum the column

|||

The probleme is that i dont want the sum of my value, in just want the pure value.

It is possible ?

Erwan

|||

The whole point of a matrix is that it aggregates the data.

Otherwise it would be a table.

In analysis services, you can drillthrough to the underlying data in the fact table. You would need to post on that forum to find out how.

|||

it's ok, i had just execute my request to blind total.

Thanks adolf

sql