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
|
|