Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Filter Subtotal
0 views
Skip to first unread message
ctmcklowe96
Dec 9, 2009, 2:16:01 PM12/9/09
to
Is it possible to filter out a subtotal row? If I have a matrix as follows,
is there a way to remove the Subtotal3 row/line?
is there a way to remove the Subtotal3 row/line?
Total
Labor 75.00
Overhead 50.00
Subtotal1 125.00
Training 50.00
Travel 50.00
Subtotal2 100.00
G&A 75.00
Subtotal3 75.00 <<---remove?
Total All 300.00
Hopefully this came out right, sorry if it did not. Is there a way to
attach an image?
vinuthan
Dec 18, 2009, 2:59:01 AM12/18/09
to
You can do the row visibiliy to false, You need to have an appropriate
expression set here . visibility = IIF( X1 = X2, false, true)
expression set here . visibility = IIF( X1 = X2, false, true)
0 new messages