Hi, I have the following data on Cross Tab report. Can anyone let me know how to filter or take out rows with Totals = 0.
|
12/2011
|
6/2012
|
7/2013
|
10/2013
|
11/2013
|
12/2013
|
1/2014
|
Total
|
17,271
|
0.00
|
-30.30
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
-30.30
|
21,893
|
0.00
|
0.00
|
0.00
|
-125.59
|
0.00
|
0.00
|
0.00
|
-125.59
|
Total
|
0.00
|
-30.30
|
0.00
|
-125.59
|
0.00
|
0.00
|
0.00
|
-155.89
|
19,595
|
-190.08
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
-190.08
|
22,536
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
-110.80
|
0.00
|
-110.80
|
Total
|
-190.08
|
0.00
|
0.00
|
0.00
|
0.00
|
-110.80
|
0.00
|
-300.88
|
145,283
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
4,101.08
|
4,101.08
|
0.00
|
32,765
|
0.00
|
0.00
|
8,520.35
|
0.00
|
0.00
|
0.00
|
0.00
|
8,520.35
|
137,670
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
4,163.86
|
4,163.86
|
0.00
|
138,888
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
84.36
|
-84.36
|
0.00
|
142,351
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
2,345.38
|
2,345.38
|
0.00
|
148,941
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
1,465.90
|
1,465.90
|
0.00
|
153,756
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
2,626.02
|
2,626.02
|
154,945
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
405.53
|
405.53
|
156,452
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
4,224.15
|
4,224.15
|
158,913
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
1,027.85
|
1,027.85
|
162,227
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
998.37
|
998.37
|
165,228
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
242.55
|
242.55
|
166,644
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
1,722.38
|
1,722.38
|
166,681
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
238.50
|
238.50
|
169,281
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
3,406.80
|
3,406.80
|
171,982
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
0.00
|
720.74
|
720.74
|
|