Spreadsheet: 777885d1650647514-index-match-help-for-a-table-book3-1-
Sheet: Pivot Table

Month | City | Category | Percentage
2021-01-01 00:00:00 | Boise | New | 0.06
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | New | 0.06
 | Las Vegas | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | New | 0.089
 | Pasco | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | New | 0.078
 |  | Used | 0.167
 | Spokane | Consigned | 0.204
 |  | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2021-02-01 00:00:00 | Boise | New | 0.06
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | New | 0.06
 | Las Vegas | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | New | 0.089
 | Pasco | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | New | 0.078
 |  | Used | 0.167
 | Spokane | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2021-03-01 00:00:00 | Boise | Consigned | 0.1
 |  | New | 0.06
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | New | 0.06
 | Las Vegas | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | New | 0.089
 | Pasco | Consigned | 0.065
 |  | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | New | 0.078
 |  | Used | 0.167
 | Spokane | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2021-05-01 00:00:00 | Boise | Consigned | 0.1935483870967742
 |  | New | 0.06
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | Consigned | 0.04
 |  | New | 0.06
 | Las Vegas | Consigned | 0.059
 |  | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | Consigned | 0.0508130081300813
 |  | New | 0.089
 | Pasco | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | New | 0.078
 |  | Used | 0.167
 | Spokane | Consigned | 0.08430947368421053
 |  | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2021-06-01 00:00:00 | Boise | Consigned | 0.093
 |  | New | 0.06
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | New | 0.06
 | Las Vegas | Consigned | 0.0779510022271715
 |  | New | 0.067
 |  | Used | 0.19
 | Lewiston | Consigned | 0.09553050505050506
 |  | New | 0.075
 | Missoula | New | 0.089
 | Pasco | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | Consigned | 0.116
 |  | New | 0.078
 |  | Used | 0.167
 | Spokane | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2021-07-01 00:00:00 | Boise | Consigned | 0.06579412805093739
 |  | New | 0.06
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | New | 0.06
 | Las Vegas | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | New | 0.089
 | Pasco | Consigned | 0.09181699029126215
 |  | New | 0.074
 | Pocatello | Consigned | 0.0501002004008016
 |  | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | New | 0.078
 |  | Used | 0.167
 | Spokane | Consigned | 0.1317321243523316
 |  | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2021-08-01 00:00:00 | Boise | Consigned | 0.082
 |  | New | 0.06
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | Consigned | 0.09808342728297632
 |  | New | 0.06
 | Las Vegas | Consigned | 0.05889281507656066
 |  | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | Consigned | 0.1165501165501165
 |  | New | 0.089
 | Pasco | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | Consigned | 0.03553660270078181
 |  | New | 0.078
 |  | Used | 0.167
 | Spokane | Consigned | 0.08424970014992504
 |  | New | 0.074
 | St. George | Consigned | 0.07886435331230283
 |  | New | 0.078
 |  | Used | 0.196
2021-09-01 00:00:00 | Boise | Consigned | 0.068
 |  | New | 0.06
 | Idaho Falls | Consigned | 0.05152524246395807
 |  | New | 0.069
 |  | Used | 0.166
 | [NAME] | Consigned | 0.029
 |  | New | 0.06
 | Las Vegas | Consigned | 0.08
 |  | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | Consigned | 0.06711409395973154
 |  | New | 0.089
 | Pasco | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | Consigned | 0.08422712933753944
 |  | New | 0.078
 |  | Used | 0.167
 | Spokane | Consigned | 0.069
 |  | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2021-10-01 00:00:00 | Boise | Consigned | 0.04123711340206185
 |  | New | 0.06
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | New | 0.06
 | Las Vegas | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | Consigned | 0.1176470588235294
 |  | New | 0.089
 | Pasco | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | Consigned | 0.052
 |  | New | 0.078
 |  | Used | 0.167
 | Spokane | Consigned | 0.088
 |  | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2021-11-01 00:00:00 | Boise | Consigned | 0.05
 |  | New | 0.06
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | Consigned | 0.05232986666666666
 |  | New | 0.06
 | Las Vegas | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | Consigned | 0.1268984545454545
 |  | New | 0.089
 | Pasco | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | New | 0.078
 |  | Used | 0.167
 | Spokane | Consigned | 0.143
 |  | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2022-01-01 00:00:00 | Boise | Consigned | 0.069
 |  | New | 0.06
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | Consigned | 0.152
 |  | New | 0.06
 | Las Vegas | Consigned | 0.126
 |  | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | Consigned | 0.182
 |  | New | 0.089
 | Pasco | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | Consigned | 0.074
 |  | New | 0.078
 |  | Used | 0.167
 | Spokane | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2022-02-01 00:00:00 | Boise | Consigned | 0.023
 |  | New | 6.66
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | Consigned | 0.012
 |  | New | 0.06
 | Las Vegas | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | Consigned | 0.03
 |  | New | 0.089
 | Pasco | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | New | 0.078
 |  | Used | 0.167
 | Spokane | Consigned | 0.084
 |  | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2021-04-01 00:00:00 | Boise | Consigned | 0.196
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | New | 0.06
 | Las Vegas | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | New | 0.089
 | Pasco | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | New | 0.078
 |  | Used | 0.167
 | Spokane | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2021-12-01 00:00:00 | Boise | Consigned | 0.0913453914552158
 | Idaho Falls | New | 0.069
 |  | Used | 0.166
 | [NAME] | Consigned | 0.09122771084337349
 |  | New | 0.06
 | Las Vegas | New | 0.067
 |  | Used | 0.19
 | Lewiston | New | 0.075
 | Missoula | Consigned | 0.07692307692307693
 |  | New | 0.089
 | Pasco | Consigned | 0.101618125
 |  | New | 0.074
 | Pocatello | New | 0.064
 |  | Used | 0.187
 | Salt Lake City | New | 0.078
 |  | Used | 0.167
 | Spokane | Consigned | 0.04178272980501393
 |  | New | 0.074
 | St. George | New | 0.078
 |  | Used | 0.196
2022-03-01 00:00:00 | Boise | Consigned | 0.065
 | Spokane | Consigned | 0.083
(blank) | (blank) | (blank) | (blank)
Grand Total