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 |
|
huynhtl
Posting Yak Master
107 Posts |
 Posted - 2009-03-17 : 17:43:43
|
Hi,I'm at a lost here. In my matrix, i have row group(codes) and column group(age) and within that column group, I have auth,client,number,and $$. I then have a subtotal,it total up correctly, except I want the auth and client to hide in the subtotal. Does this make sense? this is what i have now.... age auth----- client ------ number ------ $$yes------ jon---------- 1------------- 50.00no------- adam--------- 1------------- 35.00codea5555b6666total---yes----- adam----- 2----------85.00this is what i want.... age auth----- client ------ number ------ $$yes------ jon---------- 1------------- 50.00no------- adam--------- 1------------- 35.00codea5555b6666total-------- ------- 2----------85.00 |
|
|
huynhtl
Posting Yak Master
107 Posts |
Posted - 2009-03-17 : 18:13:29
|
| I figure out the problem!!! This is what I should had done all this time.... visibility -> expression : =not inscope("matrix1_rowgroup")--rowgroup is the name of your group for your row |
 |
|
|
|
|
|
Hide Certain Column in Matrix Subtotal