Spreadsheet: 152898d1335576755-expanding-cells-in-pivot-tables-example-salaries-at-my-company
Sheet: Sheet1

Sum of Revenue | Column Labels
Row Labels | 2009 | Grand Total
January | 16583.72999999999 | 16583.72999999999
1 | 2349.71 | 2349.71 |  |  | Do you see how all the 1s close? (are collapsed)
2 | 2857.369999999999 | 2857.369999999999
2857.369999999999 | 2857.369999999999 | 2857.369999999999 |  |  | How can I only close the 1 for January? While February is still open?
3 | 2138.940000000001 | 2138.940000000001
2138.940000000001 | 2138.940000000001 | 2138.940000000001 |  |  | or
4 | 1856.03 | 1856.03
1856.03 | 1856.03 | 1856.03 |  |  | If all were closed, How can I open only 1?
5 | 441.67 | 441.67
441.67 | 441.67 | 441.67 |  |  | The actual file is different, and there is a lag if I click 1 as it opens all of them, also it changes the space of the spreadsheet by a lot as well.
6 | 6940.009999999989 | 6940.009999999989
6940.009999999989 | 6940.009999999989 | 6940.009999999989
February | 16991.96999999998 | 16991.96999999998
1 | 2846.999999999999 | 2846.999999999999
2 | 845.2100000000004 | 845.2100000000004
845.2100000000004 | 845.2100000000004 | 845.2100000000004
3 | 981.3100000000002 | 981.3100000000002
981.3100000000002 | 981.3100000000002 | 981.3100000000002
4 | 4006.869999999997 | 4006.869999999997
4006.869999999997 | 4006.869999999997 | 4006.869999999997
5 | 1243.35 | 1243.35
1243.35 | 1243.35 | 1243.35
6 | 7068.229999999987 | 7068.229999999987
7068.229999999987 | 7068.229999999987 | 7068.229999999987
March | 10967.7 | 10967.7
1 | 2752.849999999999 | 2752.849999999999
2 | 220.71 | 220.71
220.71 | 220.71 | 220.71
3 | 1027.47 | 1027.47
1027.47 | 1027.47 | 1027.47
4 | 862.3900000000002 | 862.3900000000002
862.3900000000002 | 862.3900000000002 | 862.3900000000002
5 | 1490.420000000001 | 1490.420000000001
1490.420000000001 | 1490.420000000001 | 1490.420000000001
6 | 4613.859999999998 | 4613.859999999998
4613.859999999998 | 4613.859999999998 | 4613.859999999998
April | 16675.24999999999 | 16675.24999999999
1 | 3426.749999999999 | 3426.749999999999
2 | 685.5500000000001 | 685.5500000000001
685.5500000000001 | 685.5500000000001 | 685.5500000000001
3 | 1790.970000000001 | 1790.970000000001
1790.970000000001 | 1790.970000000001 | 1790.970000000001
4 | 2127.190000000001 | 2127.190000000001
2127.190000000001 | 2127.190000000001 | 2127.190000000001
5 | 1142.170000000001 | 1142.170000000001
1142.170000000001 | 1142.170000000001 | 1142.170000000001
6 | 7502.619999999984 | 7502.619999999984
7502.619999999984 | 7502.619999999984 | 7502.619999999984
May | 14293.56 | 14293.56
1 | 3135.839999999999 | 3135.839999999999
2 | 1369.28 | 1369.28
1369.28 | 1369.28 | 1369.28
3 | 252.79 | 252.79
252.79 | 252.79 | 252.79
4 | 4087.029999999997 | 4087.029999999997
4087.029999999997 | 4087.029999999997 | 4087.029999999997
5 | 1028.45 | 1028.45
1028.45 | 1028.45 | 1028.45
6 | 4420.169999999998 | 4420.169999999998
4420.169999999998 | 4420.169999999998 | 4420.169999999998
June | 13790.03 | 13790.03
1 | 3312.719999999999 | 3312.719999999999
2 | 1696.640000000001 | 1696.640000000001
1696.640000000001 | 1696.640000000001 | 1696.640000000001
3 | 1343.47 | 1343.47
1343.47 | 1343.47 | 1343.47
4 | 915.4900000000001 | 915.4900000000001
915.4900000000001 | 915.4900000000001 | 915.4900000000001
5 | 1396.640000000001 | 1396.640000000001
1396.640000000001 | 1396.640000000001 | 1396.640000000001
6 | 5125.069999999998 | 5125.069999999998
5125.069999999998 | 5125.069999999998 | 5125.069999999998
July | 14556.82 | 14556.82
1 | 2578.529999999999 | 2578.529999999999
2 | 657.5800000000002 | 657.5800000000002
657.5800000000002 | 657.5800000000002 | 657.5800000000002
3 | 1794.900000000001 | 1794.900000000001
1794.900000000001 | 1794.900000000001 | 1794.900000000001
4 | 3680.829999999999 | 3680.829999999999
3680.829999999999 | 3680.829999999999 | 3680.829999999999
5 | 2096.070000000001 | 2096.070000000001
2096.070000000001 | 2096.070000000001 | 2096.070000000001
6 | 3748.909999999998 | 3748.909999999998
3748.909999999998 | 3748.909999999998 | 3748.909999999998
August | 17282.54999999999 | 17282.54999999999
1 | 4816.779999999997 | 4816.779999999997
2 | 842.5500000000001 | 842.5500000000001
842.5500000000001 | 842.5500000000001 | 842.5500000000001
3 | 2591.579999999999 | 2591.579999999999
2591.579999999999 | 2591.579999999999 | 2591.579999999999
4 | 1864.950000000001 | 1864.950000000001
1864.950000000001 | 1864.950000000001 | 1864.950000000001
5 | 234.81 | 234.81
234.81 | 234.81 | 234.81
6 | 6931.879999999992 | 6931.879999999992
6931.879999999992 | 6931.879999999992 | 6931.879999999992
September | 17958.52999999999 | 17958.52999999999
1 | 4248.159999999997 | 4248.159999999997
2 | 932.5000000000002 | 932.5000000000002
932.5000000000002 | 932.5000000000002 | 932.5000000000002
3 | 451.5699999999999 | 451.5699999999999
451.5699999999999 | 451.5699999999999 | 451.5699999999999
4 | 4751.639999999997 | 4751.639999999997
4751.639999999997 | 4751.639999999997 | 4751.639999999997
5 | 1737.840000000001 | 1737.840000000001
1737.840000000001 | 1737.840000000001 | 1737.840000000001
6 | 5836.819999999994 | 5836.819999999994
5836.819999999994 | 5836.819999999994 | 5836.819999999994
October | 13229.13999999999 | 13229.13999999999
1 | 2151.11 | 2151.11
2 | 739.4300000000001 | 739.4300000000001
739.4300000000001 | 739.4300000000001 | 739.4300000000001
3 | 1813.850000000001 | 1813.850000000001
1813.850000000001 | 1813.850000000001 | 1813.850000000001
4 | 1062.28 | 1062.28
1062.28 | 1062.28 | 1062.28
5 | 1776.03 | 1776.03
1776.03 | 1776.03 | 1776.03
6 | 5686.439999999989 | 5686.439999999989
5686.439999999989 | 5686.439999999989 | 5686.439999999989
November | 17696.04 | 17696.04
1 | 3131.769999999999 | 3131.769999999999
2 | 1936.710000000001 | 1936.710000000001
1936.710000000001 | 1936.710000000001 | 1936.710000000001
3 | 2065.640000000001 | 2065.640000000001
2065.640000000001 | 2065.640000000001 | 2065.640000000001
4 | 2205.33 | 2205.33
2205.33 | 2205.33 | 2205.33
5 | 3320.97 | 3320.97
3320.97 | 3320.97 | 3320.97
6 | 5035.619999999995 | 5035.619999999995
5035.619999999995 | 5035.619999999995 | 5035.619999999995
December | 13765.26 | 13765.26
1 | 2709.27 | 2709.27
2 | 724.9300000000001 | 724.9300000000001
724.9300000000001 | 724.9300000000001 | 724.9300000000001
3 | 1142.26 | 1142.26
1142.26 | 1142.26 | 1142.26
4 | 2012.120000000001 | 2012.120000000001
2012.120000000001 | 2012.120000000001 | 2012.120000000001
5 | 2993.809999999999 | 2993.809999999999
2993.809999999999 | 2993.809999999999 | 2993.809999999999
6 | 4182.869999999999 | 4182.869999999999
4182.869999999999 | 4182.869999999999 | 4182.869999999999
Grand Total | 183790.5799999999 | 183790.5799999999