[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 844 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Xie, Kurt, A,14344 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Martinez, Troy, L,20823 | 4216.75 | 0.00 | 3578.27 | 0.00 | 638.48 |
| Hernandez, Philip,21193 | 3905.52 | 0.00 | 2181.56 | 0.00 | 1723.96 |
| Yuan, Lacey, W,12349 | 6772.14 | 0.00 | 2049.10 | 0.00 | 4723.04 |
| Green, Jennifer,12571 | 2641.39 | 0.00 | 2071.42 | 0.00 | 569.97 |
| Kumar, Alison,21200 | 3932.54 | 0.00 | 2181.56 | 0.00 | 1750.98 |
| Lu, Willie,21191 | 4169.33 | 0.00 | 2443.35 | 0.00 | 1725.98 |
| Ortega, Lance, C,12354 | 6797.13 | 0.00 | 2049.10 | 0.00 | 4748.03 |
| Blanco, Larry, E,21216 | 4935.67 | 0.00 | 2443.35 | 0.00 | 2492.32 |
| Nara, Katrina, Z,24608 | 2120.93 | 0.00 | 1000.44 | 0.00 | 1120.49 |
| Raje, Derek,12574 | 2626.39 | 0.00 | 2071.42 | 0.00 | 554.97 |
| Chapman, Clifford, C,21168 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Ruiz, Gloria,12343 | 5567.93 | 0.00 | 2049.10 | 0.00 | 3518.83 |
| Shan, Bridget,29338 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Lopez, Darren,29081 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Liu, Karen, F,14008 | 63.97 | 0.00 | 0.00 | 0.00 | 63.97 |
| Romero, Ruben,16632 | 68.87 | 0.00 | 0.00 | 0.00 | 68.87 |
| Goel, Karl,18705 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Carlson, Lance, E,22856 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Martin, Diane,13958 | 6838.64 | 0.00 | 0.00 | 2049.10 | 4789.54 |
| He, Colin, B,14300 | 5322.73 | 0.00 | 0.00 | 2071.42 | 3251.31 |
| She, Ricardo, A,14233 | 78.97 | 0.00 | 0.00 | 0.00 | 78.97 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 7.95 | 138.96 |
| Chander, Latoya, C,26138 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Chen, Clarence, R,15147 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Raje, Lacey, T,12358 | 6787.76 | 0.00 | 2071.42 | 0.00 | 4716.34 |
| Ramos, Michele, J,19574 | 96.74 | 0.00 | 0.00 | 0.00 | 96.74 |
| Raji, Carly, L,23346 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Lal, Rafael, W,28945 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Lopez, Stanley, M,28962 | 2477.53 | 0.00 | 0.00 | 0.00 | 2477.53 |
| Chander, Alisha,12572 | 2611.41 | 0.00 | 2071.42 | 0.00 | 539.99 |
| Torres, Theresa,21202 | 4632.86 | 0.00 | 2181.56 | 0.00 | 2451.30 |
| Wood, Maria,12667 | 6813.12 | 0.00 | 2049.10 | 0.00 | 4764.02 |
| Serrano, Gloria, G,21556 | 4930.68 | 0.00 | 2443.35 | 0.00 | 2487.33 |
| Suarez, Lawrence, C,26131 | 1952.45 | 0.00 | 782.99 | 0.00 | 1169.46 |
| Chapman, Alicia, A,21418 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Henderson, Cassidy,21228 | 3936.54 | 0.00 | 0.00 | 2181.56 | 1754.98 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 0.00 | 2049.10 | 618.98 |
| Sanz, Francis,12577 | 2614.08 | 0.00 | 0.00 | 2049.10 | 564.98 |
| Lin, Ronnie, D,21384 | 2921.02 | 0.00 | 0.00 | 2181.56 | 739.46 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Xie, Casey,21217 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Madan, Michele, A,12676 | 6859.46 | 0.00 | 0.00 | 2071.42 | 4788.04 |
| Lopez, Kristopher, L,21560 | 4702.39 | 0.00 | 0.00 | 2181.56 | 2520.83 |
| Zhu, Candice, S,21219 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Martinez, Ian,12585 | 2629.07 | 0.00 | 0.00 | 2049.10 | 579.97 |
| Nara, Cedric, M,21875 | 4921.69 | 0.00 | 0.00 | 2443.35 | 2478.34 |
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 0.00 | 2071.42 | 4749.05 |
| Hernandez, Jacquelyn, J,21568 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 0.00 | 2443.35 | 2482.23 |
| Gonzalez, Kaylee, L,21895 | 4657.51 | 0.00 | 0.00 | 2181.56 | 2475.95 |
| Shen, Kathryn, R,21957 | 4919.30 | 0.00 | 0.00 | 2443.35 | 2475.95 |
| Carlson, Jill,21886 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Yang, Darryl, K,21571 | 4624.91 | 0.00 | 0.00 | 2181.56 | 2443.35 |
| Arthur, Jay, R,12694 | 6785.13 | 0.00 | 0.00 | 2049.10 | 4736.03 |
| Ferrier, Jenny,21955 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Kovár, Barry, A,21570 | 4705.48 | 0.00 | 0.00 | 2181.56 | 2523.92 |
| Li, Jack, J,14071 | 5617.92 | 0.00 | 0.00 | 2049.10 | 3568.82 |
| Gomez, Marvin, C,28479 | 831.33 | 0.00 | 0.00 | 0.00 | 831.33 |
| Madan, Bruce, G,18206 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Deng, Tracy, E,21978 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Sullivan, Henry, L,20603 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
Generated 2025-12-23 04:00:53.150 UTC