environment: SQL server 2008 enterprise edition.
I am using Rollup clause and you how it shows aggregation at various levels WITH NULL values showing different levels of rollups e.g. ROllup(year,month,week) would show subtotals at each level.
I want it rolled up and yet want to see only highest elvel of aggregation. so I dont want to see any null values.
ANy idea how can i do that?
Regards Manjot