Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joshker
Starting Member
6 Posts |
 Posted - 2007-03-13 : 10:59:58
|
| Hi All,I have a table which has a country, division, category, product, Valuetype, valuedata looks like this:Country division, category, product, Valuetype, value---------------------------------------------------------------------UK Division1 Food Pizza Volume 10000 UK Division1 Food Pizza Revenue 2000UK Division1 Food Pizza ROI 4.5UK Division2 Food Pizza Volume 14000 UK Division2 Food Pizza Revenue 2400UK Division2 Food Pizza ROI 4.1UK Division2 Drinks Cola Volume 14000 UK Division2 Drinks Cola Revenue 2400UK Division2 Drinks Cola ROI 4.1I want to build a drill-through report to be grouped on country, division, category and product.Can someone help me with some suggestions?CheersJosh |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
MAtrix Report with drill-through