[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SKIP 500 < SKIP 125 > < TAKE 124 >
124 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Lu, Willie,21191 | 4169.33 | 0.00 | 2443.35 | 0.00 | 1725.98 |
| Tang, Rafael, A,11908 | 8079.05 | 0.00 | 3374.99 | 0.00 | 4704.06 |
| Rana, Meagan, M,11914 | 8165.96 | 0.00 | 3374.99 | 0.00 | 4790.97 |
| Carlson, Shannon, C,11009 | 8091.33 | 3374.99 | 0.00 | 2297.28 | 2419.06 |
| Raje, Rafael, M,13000 | 6799.45 | 0.00 | 0.00 | 2071.42 | 4728.03 |
| Carlson, Robin,19786 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Zeng, Brittney, K,13670 | 178.45 | 0.00 | 0.00 | 0.00 | 178.45 |
| Ruiz, Bruce, W,16171 | 103.86 | 0.00 | 0.00 | 0.00 | 103.86 |
| Ruiz, Kari, L,12695 | 192.97 | 0.00 | 0.00 | 0.00 | 192.97 |
| Beck, Derek,17322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Chen, Jaclyn, C,22847 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Gray, Stephanie,17064 | 4506.76 | 0.00 | 3578.27 | 0.00 | 928.49 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 0.00 | 4693.04 |
| Zeng, Jon, O,14310 | 5200.66 | 0.00 | 0.00 | 2071.42 | 3129.24 |
| Sanchez, Olivia, J,14278 | 177.46 | 0.00 | 0.00 | 0.00 | 177.46 |
| Gao, Krystal,25821 | 1879.07 | 0.00 | 699.10 | 0.00 | 1179.97 |
| Carlson, Philip, P,11915 | 8143.00 | 0.00 | 3374.99 | 0.00 | 4768.01 |
| Rana, Molly,21554 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Ramos, Mary, B,15019 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Ramos, Paula, W,21376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vazquez, Rodney, M,13047 | 241.93 | 0.00 | 0.00 | 0.00 | 241.93 |
| Chandra, Ann,18209 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Suri, Ronald,18214 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Zeng, Louis,18903 | 4143.74 | 0.00 | 3578.27 | 565.47 | 0.00 |
| Saunders, Micheal,17513 | 4260.24 | 0.00 | 3578.27 | 681.97 | 0.00 |
| Alonso, Danny, S,18217 | 6056.61 | 0.00 | 3578.27 | 2478.34 | 0.00 |
| Smith, Christian, L,14313 | 222.44 | 0.00 | 0.00 | 0.00 | 222.44 |
| Zhu, Wesley, L,19624 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Raje, Gregory, C,22911 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shen, Alison, A,16614 | 71.16 | 0.00 | 0.00 | 0.00 | 71.16 |
| Torres, Melinda, J,14033 | 6809.96 | 0.00 | 0.00 | 2071.42 | 4738.54 |
| Raman, Johnathan,19103 | 63.91 | 0.00 | 0.00 | 0.00 | 63.91 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Huang, Eugene, L,11001 | 6383.88 | 3374.99 | 0.00 | 2419.93 | 588.96 |
| Johnson, Logan, K,22931 | 3882.55 | 0.00 | 0.00 | 3882.55 | 0.00 |
| Lal, Katie, E,18210 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 0.00 | 3490.03 | 0.00 |
| Shan, Mario,25271 | 1854.58 | 0.00 | 699.10 | 0.00 | 1155.48 |
| Schmidt, Kaitlin,13628 | 191.25 | 0.00 | 0.00 | 0.00 | 191.25 |
| Torres, Mathew, L,18900 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Sara, Edgar, A,11104 | 8173.03 | 0.00 | 3399.99 | 2334.98 | 2438.06 |
| Lal, Karl, R,14264 | 5217.73 | 0.00 | 0.00 | 2822.76 | 2394.97 |
| Harris, Eduardo, S,18238 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Jordan, Ross, F,11124 | 8129.02 | 0.00 | 3399.99 | 2309.97 | 2419.06 |
| Xu, Barbara,14074 | 59.88 | 0.00 | 0.00 | 0.00 | 59.88 |
| Huang, Omar, C,14232 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Sai, Terrance,19106 | 64.95 | 0.00 | 0.00 | 0.00 | 64.95 |
| Gomez, Arthur,24917 | 2179.91 | 0.00 | 0.00 | 1000.44 | 1179.47 |
| Sanz, Rodney,16926 | 44.95 | 0.00 | 0.00 | 0.00 | 44.95 |
| Xu, Tara,19592 | 5377.23 | 0.00 | 3578.27 | 0.00 | 1798.96 |
| Jimenez, Jill,11028 | 6474.62 | 3374.99 | 0.00 | 0.00 | 3099.63 |
| Lal, Darrell,19953 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Xie, Derek,14287 | 5141.43 | 0.00 | 0.00 | 2049.10 | 3092.33 |
| Gonzalez, Heidi, Z,13157 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Ramos, Stacy, D,18261 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Williams, Alexis, D,14674 | 142.47 | 0.00 | 0.00 | 0.00 | 142.47 |
| Thomas, Sydney,14322 | 5111.44 | 0.00 | 0.00 | 2049.10 | 3062.34 |
| Martinez, Harold, J,20604 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Gonzalez, Donald,11079 | 32.96 | 0.00 | 0.00 | 0.00 | 32.96 |
| Prasad, Gerald, B,12035 | 81.24 | 0.00 | 0.00 | 0.00 | 81.24 |
| Xie, Cristina, C,17050 | 4496.23 | 0.00 | 3578.27 | 0.00 | 917.96 |
| Mehta, Brett,11450 | 8173.26 | 0.00 | 3374.99 | 2370.22 | 2428.05 |
| Price, Ian, J,22401 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Zeng, Curtis, E,26669 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Lin, Wesley,21407 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Gonzalez, Meredith,22171 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 0.00 | 2049.10 | 4842.02 |
| Raje, Terry, A,28311 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Sanz, Mathew, L,14557 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Nara, Cristina, R,19792 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Rowe, Jacquelyn, I,13615 | 146.91 | 0.00 | 0.00 | 7.95 | 138.96 |
| Sun, Rafael,26749 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Gutierrez, Armando,29310 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Chande, Michele, C,13078 | 6850.46 | 0.00 | 0.00 | 2071.42 | 4779.04 |
| Lopez, Edgar, O,17346 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Li, Jake, L,19583 | 97.96 | 0.00 | 0.00 | 0.00 | 97.96 |
| Guo, Leah, R,19562 | 5314.25 | 0.00 | 3578.27 | 0.00 | 1735.98 |
| Ortega, Anne,13011 | 6819.11 | 0.00 | 0.00 | 2049.10 | 4770.01 |
| Alvarez, Stacy,11901 | 8248.01 | 0.00 | 3399.99 | 0.00 | 4848.02 |
| Hall, Jeremiah, M,18250 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Torres, Neil,17305 | 196.97 | 0.00 | 0.00 | 196.97 | 0.00 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 84.95 | 259.09 |
| Fernandez, Ross, R,11763 | 76.65 | 0.00 | 0.00 | 24.49 | 52.16 |
| Hu, Aimee, R,27981 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Blanco, Rodney, A,20158 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Deng, Kurt, D,13635 | 215.74 | 0.00 | 0.00 | 32.27 | 183.47 |
| Sara, Ebony,24923 | 2159.40 | 0.00 | 0.00 | 1000.44 | 1158.96 |
| Chande, Alvin, W,24893 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Gutierrez, Diana,19676 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Serrano, Leslie, T,14014 | 62.27 | 0.00 | 0.00 | 0.00 | 62.27 |
| Gutierrez, Natasha,17048 | 4382.75 | 0.00 | 3578.27 | 0.00 | 804.48 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 0.00 | 2049.10 | 4713.05 |
| Moreno, Kristine, K,28481 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Ray, Bobby,23575 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Moreno, Janet, L,15592 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Shen, Jodi, A,22028 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Martin, Larry,18254 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| James, Evan, V,11119 | 85.22 | 0.00 | 0.00 | 35.23 | 49.99 |
| Xie, Alvin, M,16617 | 160.55 | 0.00 | 0.00 | 69.97 | 90.58 |
| Zhou, Cedric,17514 | 4142.23 | 0.00 | 3578.27 | 563.96 | 0.00 |
| Nara, Sharon,18482 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Shan, Yolanda,12702 | 6911.10 | 0.00 | 0.00 | 2049.10 | 4862.00 |
| Hernandez, Leslie, D,12990 | 6829.47 | 0.00 | 0.00 | 2071.42 | 4758.05 |
| Raje, Tara, F,28483 | 765.32 | 0.00 | 0.00 | 0.00 | 765.32 |
| Pal, Alison,13042 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Sanchez, Terrance,19584 | 116.74 | 0.00 | 0.00 | 0.00 | 116.74 |
| She, Rafael, I,20152 | 4142.75 | 0.00 | 3578.27 | 0.00 | 564.48 |
| Ferrier, Leslie, M,28535 | 2433.04 | 0.00 | 0.00 | 0.00 | 2433.04 |
| Raje, Jodi, E,19630 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Kapoor, Pedro, H,24229 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Hu, Barbara,19567 | 104.96 | 0.00 | 0.00 | 0.00 | 104.96 |
| Sanz, Marvin,19612 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 0.00 | 3191.58 |
| Goel, Karl,18705 | 59.26 | 0.00 | 0.00 | 0.00 | 59.26 |
| Alvarez, Mathew, L,17494 | 111.96 | 0.00 | 0.00 | 0.00 | 111.96 |
| Xu, Grant, M,19266 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Carlson, Jose,19954 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Van, Brenda, J,24890 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Zhang, Amy,18307 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Serrano, Diane, E,14857 | 87.97 | 0.00 | 0.00 | 0.00 | 87.97 |
| Hill, James, S,29317 | 2438.06 | 0.00 | 0.00 | 0.00 | 2438.06 |
| Ruiz, Krista, C,13081 | 6772.15 | 0.00 | 0.00 | 2049.10 | 4723.05 |
| Zhao, Gilbert,23119 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
Generated 2025-12-24 07:38:15.341 UTC