[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1992 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wood, Samantha, L,19022 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Diaz, Arianna, C,14902 | 1538.58 | 0.00 | 699.10 | 0.00 | 839.48 |
| Ye, Margaret,28688 | 901.35 | 0.00 | 0.00 | 0.00 | 901.35 |
| Alonso, Dana, J,23683 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Collins, Mackenzie, I,23340 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Butler, Julia, J,26780 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Butler, Cameron, W,23812 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Gray, Melanie, S,20355 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Perez, Rebekah, C,21910 | 1174.48 | 0.00 | 0.00 | 0.00 | 1174.48 |
| Patterson, Samuel, R,13386 | 84.96 | 0.00 | 0.00 | 0.00 | 84.96 |
| Mehta, Jillian, H,21834 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Perry, Grace, E,27635 | 93.46 | 0.00 | 0.00 | 0.00 | 93.46 |
| Howard, Ian, L,28275 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Martinez, John, J,24287 | 100.09 | 0.00 | 0.00 | 0.00 | 100.09 |
| Powell, Ashley,28705 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Perez, Erick,24925 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Simmons, Ian, M,21733 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| King, Jennifer, C,20762 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Wright, Allison, R,16084 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perez, Stanley,15818 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Butler, Robert, D,14781 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Jones, Morgan, C,11487 | 53.99 | 0.00 | 0.00 | 0.00 | 53.99 |
| Lu, Jenny, J,27395 | 75.47 | 0.00 | 0.00 | 0.00 | 75.47 |
| Moore, Madison,23327 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Patterson, Seth, J,19846 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Rogers, Isabella,18588 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Luo, Misty, R,19067 | 3380.91 | 0.00 | 0.00 | 1000.44 | 2380.47 |
| Kumar, Kara,26046 | 93.48 | 0.00 | 0.00 | 0.00 | 93.48 |
| Cox, Adrian, J,20443 | 39.47 | 0.00 | 0.00 | 0.00 | 39.47 |
| Hernandez, Carlos,20119 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Bailey, Megan, C,15292 | 54.96 | 0.00 | 0.00 | 0.00 | 54.96 |
| Jones, Joseph,13921 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Srini, Ross,17636 | 73.96 | 0.00 | 0.00 | 0.00 | 73.96 |
| Brooks, Sebastian,12638 | 38.47 | 0.00 | 0.00 | 0.00 | 38.47 |
| King, Katelyn,16867 | 2381.94 | 0.00 | 0.00 | 0.00 | 2381.94 |
| Lopez, Jenna, M,25977 | 4624.83 | 0.00 | 3374.99 | 0.00 | 1249.84 |
| Bryant, Isabel, L,25986 | 4624.83 | 0.00 | 3374.99 | 0.00 | 1249.84 |
| Ward, Julia, M,23815 | 724.47 | 0.00 | 0.00 | 0.00 | 724.47 |
| Madan, Pamela,18502 | 1760.47 | 0.00 | 0.00 | 0.00 | 1760.47 |
| Parker, Adam, R,18228 | 1709.98 | 0.00 | 0.00 | 0.00 | 1709.98 |
| Carter, Blake, E,24698 | 574.98 | 0.00 | 0.00 | 0.00 | 574.98 |
| Diaz, Brandi,16424 | 5738.38 | 0.00 | 0.00 | 2181.56 | 3556.82 |
| Griffin, Vanessa,29269 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Alvarez, Michele, J,11844 | 124.97 | 0.00 | 0.00 | 0.00 | 124.97 |
| Hayes, Kelly, M,28974 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| White, Nicholas, G,26494 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Stewart, Jesse,18913 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Lopez, Luke,15563 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Navarro, Joan,19180 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Diaz, Alexis,11877 | 42.95 | 0.00 | 0.00 | 0.00 | 42.95 |
| Malhotra, Martin,12651 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Kumar, Connor, G,19843 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Green, Allison,16111 | 2340.94 | 0.00 | 0.00 | 0.00 | 2340.94 |
| Clark, Ian, L,18545 | 1725.98 | 0.00 | 0.00 | 0.00 | 1725.98 |
| Rivera, Chloe, R,11865 | 114.92 | 0.00 | 0.00 | 0.00 | 114.92 |
| Young, Isabella,11857 | 124.97 | 0.00 | 0.00 | 0.00 | 124.97 |
| Adams, Allison, L,19419 | 1602.47 | 0.00 | 0.00 | 782.99 | 819.48 |
| Gomez, Pedro,24288 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| King, Carlos, M,24519 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Goel, Jaime, W,22053 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Taylor, Austin, L,19799 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Parker, Robert, C,14693 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Madan, Kristina, A,28698 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Williams, Julia,23474 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Powell, Jordan, E,18548 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Srini, Rebekah,28335 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Cook, Katherine, R,26479 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Baker, Maria, K,15911 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Wood, Kelly, G,28743 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| King, Jenna, R,20015 | 564.99 | 0.00 | 0.00 | 0.00 | 564.99 |
| Gonzalez, Dalton, E,20003 | 579.97 | 0.00 | 0.00 | 0.00 | 579.97 |
| Alexander, Ian, D,26281 | 3335.24 | 0.00 | 0.00 | 2071.42 | 1263.82 |
| Adams, Jonathan,28247 | 5962.34 | 0.00 | 3578.27 | 0.00 | 2384.07 |
| Zheng, Lacey, C,11417 | 11248.46 | 0.00 | 0.00 | 4511.07 | 6737.39 |
| She, Claudia, C,27188 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Kumar, Drew, W,14889 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Torres, Javier, R,12274 | 34.99 | 0.00 | 0.00 | 0.00 | 34.99 |
| Anderson, Noah, A,23301 | 56.96 | 0.00 | 0.00 | 0.00 | 56.96 |
| Rivera, Jacqueline,16212 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| She, Priscilla,18630 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Diaz, Lucas,27187 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Chander, Shawna, H,12516 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Rana, Joel,26477 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Richardson, Maria, L,22157 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Butler, Jessica, K,15370 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Raje, Deborah, W,23229 | 28.48 | 0.00 | 0.00 | 0.00 | 28.48 |
| Vazquez, Brandi,27160 | 31.73 | 0.00 | 0.00 | 0.00 | 31.73 |
| Raman, Stanley, L,19420 | 4314.88 | 0.00 | 699.10 | 0.00 | 3615.78 |
| Nath, Raul,27881 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Gonzales, Aaron,18804 | 1810.46 | 0.00 | 0.00 | 0.00 | 1810.46 |
| Romero, Cheryl, A,25786 | 2329.98 | 0.00 | 0.00 | 0.00 | 2329.98 |
| Allen, Jordan, L,19835 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Cai, Dennis,28563 | 1197.97 | 0.00 | 0.00 | 0.00 | 1197.97 |
| Bell, Gabriella,26715 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Luo, Jaime, E,25836 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Hughes, Connor, S,14488 | 67.93 | 0.00 | 0.00 | 0.00 | 67.93 |
| Jai, Kenneth, D,16202 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Moyer, Joy,28422 | 34.89 | 0.00 | 0.00 | 0.00 | 34.89 |
| Hu, Rafael, J,11418 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| King, Kaylee, T,12891 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Ross, Ana, T,12899 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Martinez, Nancy, E,13712 | 4503.84 | 0.00 | 0.00 | 2181.56 | 2322.28 |
| Zhu, Kelvin, R,28666 | 4822.11 | 0.00 | 3578.27 | 0.00 | 1243.84 |
| Diaz, Marissa, C,29265 | 4320.62 | 0.00 | 3578.27 | 0.00 | 742.35 |
| Smith, Julia,21282 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Moore, Dylan, H,23231 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Romero, Michele, K,24214 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Hu, Colleen, J,12747 | 4384.07 | 0.00 | 0.00 | 2049.10 | 2334.97 |
| King, Mary, O,26709 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| He, Crystal, S,24634 | 130.56 | 0.00 | 0.00 | 0.00 | 130.56 |
| Kumar, Leonard,21932 | 1158.46 | 0.00 | 0.00 | 0.00 | 1158.46 |
| Garcia, Ashley,21293 | 1763.97 | 0.00 | 0.00 | 0.00 | 1763.97 |
| Lopez, Richard, L,25571 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Malhotra, Shane, E,23603 | 2372.95 | 0.00 | 0.00 | 0.00 | 2372.95 |
| Gutierrez, Randall,21506 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Xie, Yolanda,12841 | 5933.25 | 0.00 | 3578.27 | 0.00 | 2354.98 |
| Walker, Olivia,19887 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Patel, Erick, C,19668 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Scott, Blake, D,14638 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Ramos, Sheila,15076 | 96.46 | 0.00 | 0.00 | 0.00 | 96.46 |
| Sanchez, Jermaine, D,25684 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Dominguez, Randall, M,12131 | 9687.72 | 0.00 | 0.00 | 4863.69 | 4824.03 |
| He, Marshall, R,24191 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Sanchez, Brandy,12522 | 5888.24 | 0.00 | 3578.27 | 0.00 | 2309.97 |
Generated 2025-12-24 06:48:03.828 UTC