Spreadsheet: 86688d1286644627-return-range-based-on-drop-down-pivotfilterdropdown
Sheet: Sheet1

 | YEAR | JUL | AUG | SEP |  |  | Select Case # | Case1
 | 2006-07 | 698.946608 | 841.182482 | 675.450198
 | 2007-08
 | 2008-09 | 606.646322 | 689.568261 | 692.1667835
 | 2009-10 |  |  |  | << IF I1=Case1, return range C13:E19, IF I1=Case2, return range C23:E29, etc.
 | 2010-11 | 618.9430135 | 702.941036 | 705.452792
 | 2011-12
 | 2012-13 | 632.021498 | 717.367532 | 719.9803665 |  |  |  |  |  |  |  |  | Here is another Anser
 |  |  |  |  |  |  |  |  |  |  |  |  | Filter the Pivot table click the below
 |  |  |  |  |  |  |  |  |  |  |  |  | Case | Case1
Case1 | YEAR | JUL | AUG | SEP |  |  | Case | YEAR | JUL | AUG | SEP |  |  | Data
Case1 | 2006-07 | 698.946608 | 841.182482 | 675.450198 |  |  | Case1 | 2006-07 | 698.946608 | 841.182482 | 675.450198 |  | YEAR | Sum of JUL | Sum of AUG | Sum of SEP
Case1 | 2007-08 | 598.032287 | 680.279773 | 682.922126 |  |  | Case1 | 2007-08 | 598.032287 | 680.279773 | 682.922126 |  | 2006-07 | 698.946608 | 841.182482 | 675.450198
Case1 | 2008-09 | 606.646322 | 689.568261 | 692.1667835 |  |  | Case1 | 2008-09 | 606.646322 | 689.568261 | 692.1667835 |  | 2007-08 | 598.032287 | 680.279773 | 682.922126
Case1 | 2009-10 | 612.8586245 | 696.287745 | 698.831703 |  |  | Case1 | 2009-10 | 612.8586245 | 696.287745 | 698.831703 |  | 2008-09 | 606.646322 | 689.568261 | 692.1667835
Case1 | 2010-11 | 618.9430135 | 702.941036 | 705.452792 |  |  | Case1 | 2010-11 | 618.9430135 | 702.941036 | 705.452792 |  | 2009-10 | 612.8586245 | 696.287745 | 698.831703
Case1 | 2011-12 | 624.931691 | 709.76786 | 712.5291815 |  |  | Case1 | 2011-12 | 624.931691 | 709.76786 | 712.5291815 |  | 2010-11 | 618.9430135 | 702.941036 | 705.452792
Case1 | 2012-13 | 632.021498 | 717.367532 | 719.9803665 |  |  | Case1 | 2012-13 | 632.021498 | 717.367532 | 719.9803665 |  | 2011-12 | 624.931691 | 709.76786 | 712.5291815
 |  |  |  |  |  |  | Case2 | 2006-07 | 267.584836 | 276.172693 | 244.330196 |  | 2012-13 | 632.021498 | 717.367532 | 719.9803665
 |  |  |  |  |  |  | Case2 | 2007-08 | 267.584836 | 276.172693 | 262.287014 |  | Grand Total | 4392.380044 | 5037.394689000001 | 4887.3331505
Case2 | YEAR | JUL | AUG | SEP |  |  | Case2 | 2008-09 | 250.51359803 | 260.1821603 | 262.25229059
Case2 | 2006-07 | 267.584836 | 276.172693 | 244.330196 |  |  | Case2 | 2009-10 | 253.44335136 | 263.19116837 | 265.288608
Case2 | 2007-08 | 267.584836 | 276.172693 | 262.287014 |  |  | Case2 | 2010-11 | 255.10502013 | 264.82851143 | 266.926869
Case2 | 2008-09 | 250.51359803 | 260.1821603 | 262.25229059 |  |  | Case2 | 2011-12 | 257.70649919 | 267.56464863 | 269.71567773
Case2 | 2009-10 | 253.44335136 | 263.19116837 | 265.288608 |  |  | Case2 | 2012-13 | 260.18360881 | 270.06792541 | 272.2176349
Case2 | 2010-11 | 255.10502013 | 264.82851143 | 266.926869 |  |  | Case3 | 2006-07 | 356.837273 | 374.666709 | 349.485024
Case2 | 2011-12 | 257.70649919 | 267.56464863 | 269.71567773 |  |  | Case3 | 2007-08 | 325.6735875 | 332.76623542 | 335.78062837
Case2 | 2012-13 | 260.18360881 | 270.06792541 | 272.2176349 |  |  | Case3 | 2008-09 | 329.31730554 | 336.46398299 | 339.52013178
 |  |  |  |  |  |  | Case3 | 2009-10 | 331.1730702 | 338.23537601 | 341.29624124
 |  |  |  |  |  |  | Case3 | 2010-11 | 334.45298329 | 341.66816263 | 344.81346168
Case3 | YEAR | JUL | AUG | SEP |  |  | Case3 | 2011-12 | 337.56652075 | 344.74462058 | 347.86513204
Case3 | 2006-07 | 356.837273 | 374.666709 | 349.485024 |  |  | Case3 | 2012-13 | 340.23160619 | 347.37665971 | 350.47969858
Case3 | 2007-08 | 325.6735875 | 332.76623542 | 335.78062837 |  |  | Case4 | 2006-07 | 776.175012 | 770.250887 | 780.460532
Case3 | 2008-09 | 329.31730554 | 336.46398299 | 339.52013178 |  |  | Case4 | 2007-08 | 766.140116034927 | 779.324853401392 | 787.946071592875
Case3 | 2009-10 | 331.1730702 | 338.23537601 | 341.29624124 |  |  | Case4 | 2008-09 | 776.264510567191 | 789.486455377738 | 798.158611526011
Case3 | 2010-11 | 334.45298329 | 341.66816263 | 344.81346168 |  |  | Case4 | 2009-10 | 792.876374856824 | 805.847030465222 | 814.508097696385
Case3 | 2011-12 | 337.56652075 | 344.74462058 | 347.86513204 |  |  | Case4 | 2010-11 | 800.037979751778 | 813.377532123638 | 822.276600879748
Case3 | 2012-13 | 340.23160619 | 347.37665971 | 350.47969858 |  |  | Case4 | 2011-12 | 805.86349032108 | 819.070712062384 | 827.896931681955
 |  |  |  |  |  |  | Case4 | 2012-13 | 808.562252354703 | 821.6692269179 | 830.468036301579
Case4 | YEAR | JUL | AUG | SEP
Case4 | 2006-07 | 776.175012 | 770.250887 | 780.460532
Case4 | 2007-08 | 766.140116034927 | 779.324853401392 | 787.946071592875
Case4 | 2008-09 | 776.264510567191 | 789.486455377738 | 798.158611526011
Case4 | 2009-10 | 792.876374856824 | 805.847030465222 | 814.508097696385
Case4 | 2010-11 | 800.037979751778 | 813.377532123638 | 822.276600879748
Case4 | 2011-12 | 805.86349032108 | 819.070712062384 | 827.896931681955
Case4 | 2012-13 | 808.562252354703 | 821.6692269179 | 830.468036301579