Hi Everyone,
I am trying to get something like this using matrix in reporting services
The problem is, in the total group, the GST value and Net ( Net = Value + GST) can't added into the total group in the matrix.
Can somebody help... Thanks a lot.
You can use InScope in a matrix to determine 'where you are' e.g. are you a subtotal cell, are you within a particular column or row grouping
You can also create hidden groups
This helps to deal with non additive measures
In fact here's another post that may help
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1884435&SiteID=1
|||Thanks a lot..
That help me a lot...
No comments:
Post a Comment