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