[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 1500 > < TAKE 125 >
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Madan, Stanley,19602 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Gao, Krystal,25821 | 1879.07 | 0.00 | 699.10 | 0.00 | 1179.97 |
| Liu, Christy,19784 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Ortega, Danny, K,19794 | 6098.58 | 0.00 | 3578.27 | 0.00 | 2520.31 |
| Deng, Devon, H,19967 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Navarro, Casey,19795 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Shan, Derek, R,19782 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| Alonso, Gloria, S,19964 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Hu, Lacey,19948 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Barnes, Mariah, H,19621 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Lopez, Jay, A,19965 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Luo, Raul, Q,20154 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Ramos, Dana, D,25919 | 1248.08 | 0.00 | 699.10 | 0.00 | 548.98 |
| Thomas, Christopher, M,20242 | 6068.45 | 0.00 | 3578.27 | 0.00 | 2490.18 |
| Wang, Valerie,20217 | 6089.59 | 0.00 | 3578.27 | 0.00 | 2511.32 |
| She, Valerie, C,20226 | 6067.20 | 0.00 | 3578.27 | 0.00 | 2488.93 |
| Harrison, Colleen, L,20219 | 6044.59 | 0.00 | 3578.27 | 0.00 | 2466.32 |
| Browning, Janet,19979 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Shan, Colin,25921 | 1253.07 | 0.00 | 699.10 | 0.00 | 553.97 |
| Madan, Jay, L,20156 | 4139.75 | 0.00 | 3578.27 | 561.48 | 0.00 |
| Chander, Shawn, S,20216 | 5338.74 | 0.00 | 3578.27 | 0.00 | 1760.47 |
| Anand, Carly,25918 | 1260.58 | 0.00 | 699.10 | 0.00 | 561.48 |
| Arthur, Raymond, S,20228 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Guo, Tiffany,25927 | 1272.52 | 0.00 | 699.10 | 0.00 | 573.42 |
| Kapoor, Kristina,11997 | 7029.78 | 0.00 | 3399.99 | 1249.84 | 2379.95 |
| Ashe, Deanna,20284 | 5328.23 | 0.00 | 3578.27 | 0.00 | 1749.96 |
| Vazquez, Joanna, J,11990 | 8164.01 | 0.00 | 3374.99 | 0.00 | 4789.02 |
| Wu, Laura,20615 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Zheng, Aimee, H,24283 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Wang, Curtis, A,13108 | 5718.66 | 0.00 | 0.00 | 2071.42 | 3647.24 |
| Garcia, Andre, H,12705 | 6854.11 | 0.00 | 0.00 | 2049.10 | 4805.01 |
| Ms., Rusek, Pearlie, J.,21945 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Shen, Gilbert, C,12005 | 6984.81 | 0.00 | 3399.99 | 0.00 | 3584.82 |
| Lal, Colin, M,16640 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chande, Arturo, H,14860 | 67.26 | 0.00 | 0.00 | 0.00 | 67.26 |
| Suri, Gerald,13617 | 116.92 | 0.00 | 0.00 | 0.00 | 116.92 |
| Shen, Nichole,12999 | 6840.46 | 0.00 | 0.00 | 2071.42 | 4769.04 |
| Lal, Devon, L,15237 | 66.26 | 0.00 | 0.00 | 0.00 | 66.26 |
| Rubio, Jay,15179 | 4444.89 | 0.00 | 0.00 | 2071.42 | 2373.47 |
| Zimmerman, Krystal,17228 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Yuan, Roger,19622 | 61.75 | 0.00 | 0.00 | 0.00 | 61.75 |
| Suarez, Meredith,15032 | 3800.08 | 0.00 | 0.00 | 2049.10 | 1750.98 |
| Chen, Rosa,23435 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Yuan, Alicia,25225 | 2129.92 | 0.00 | 0.00 | 1000.44 | 1129.48 |
| Alonso, Teresa,13138 | 83.97 | 0.00 | 0.00 | 58.98 | 24.99 |
| Fernandez, Nancy,14854 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Blanco, Billy,23316 | 2835.02 | 0.00 | 0.00 | 2181.56 | 653.46 |
| Reed, Steven,24373 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Chen, Clarence, R,15147 | 97.45 | 0.00 | 0.00 | 0.00 | 97.45 |
| Russell, Jonathan,18896 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Shan, Dylan,19677 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Hernandez, Melody, E,28212 | 619.46 | 0.00 | 0.00 | 0.00 | 619.46 |
| Gonzalez, Summer, L,20266 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Gill, Kristy,13669 | 102.43 | 0.00 | 0.00 | 0.00 | 102.43 |
| Sanz, Bruce,23117 | 3931.52 | 0.00 | 0.00 | 2181.56 | 1749.96 |
| Sullivan, Dominic, M,22840 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Raje, Carly, J,15576 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Moreno, Meghan, J,15152 | 4464.57 | 0.00 | 0.00 | 2049.10 | 2415.47 |
| Torres, Meghan, I,21256 | 3917.54 | 0.00 | 2181.56 | 0.00 | 1735.98 |
| Sanz, Monique, R,24273 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Rai, Brendan, A,21569 | 4960.16 | 0.00 | 2443.35 | 0.00 | 2516.81 |
| Chander, Maurice, L,14086 | 31.27 | 0.00 | 0.00 | 0.00 | 31.27 |
| Moreno, Deanna,28941 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Pal, Alison,13042 | 84.47 | 0.00 | 0.00 | 0.00 | 84.47 |
| Dominguez, Kellie, E,17244 | 86.27 | 0.00 | 0.00 | 0.00 | 86.27 |
| Sanz, Walter, J,18195 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Carlson, Armando,17484 | 126.96 | 0.00 | 0.00 | 21.98 | 104.98 |
| Cai, Curtis,21259 | 3907.54 | 0.00 | 2181.56 | 0.00 | 1725.98 |
| Cai, Roger, A,13002 | 294.94 | 0.00 | 0.00 | 167.99 | 126.95 |
| Perez, Janelle,16172 | 186.04 | 0.00 | 0.00 | 0.00 | 186.04 |
| Ramos, Jerome, L,29187 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Ramos, Randall,21572 | 4659.90 | 0.00 | 2181.56 | 0.00 | 2478.34 |
| Ashe, Jimmy, S,28959 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Sun, Aimee, R,18319 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Xie, Mitchell, B,20993 | 4262.04 | 0.00 | 3578.27 | 0.00 | 683.77 |
| Anand, Alícia, J,29113 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Ramos, Jay, D,21882 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Perry, Gavin, M,12578 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Shan, Shawna, K,27869 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
| Guo, Sandra,23664 | 3941.53 | 0.00 | 0.00 | 2181.56 | 1759.97 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 0.00 | 4794.04 |
| Martin, Byron, E,25217 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nath, Alvin, R,29301 | 134.98 | 0.00 | 0.00 | 0.00 | 134.98 |
| Simmons, Isabel, H,26432 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Mehta, Carolyn,28205 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Gomez, Naomi, E,24300 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Dominguez, Josue, R,15600 | 4590.40 | 0.00 | 0.00 | 2071.42 | 2518.98 |
| Gill, Theodore,11149 | 41.26 | 0.00 | 0.00 | 0.00 | 41.26 |
| Patel, Cynthia, M,15222 | 123.45 | 0.00 | 0.00 | 0.00 | 123.45 |
| Goel, Tonya,29123 | 23.97 | 0.00 | 0.00 | 0.00 | 23.97 |
| Shen, Devon, G,27358 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 2049.10 | 1764.96 |
| Raji, Corey,25058 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Srini, Deanna,15182 | 4391.41 | 0.00 | 0.00 | 2071.42 | 2319.99 |
| Lopez, Chelsea,24369 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Romero, Deanna, K,23570 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Malhotra, Veronica, J,25922 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Suri, Stanley, J,27496 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Ashe, Brad,25228 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Martinez, Emma,16734 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Xu, Alisha,14100 | 226.26 | 0.00 | 0.00 | 0.00 | 226.26 |
| Gutierrez, Micheal, S,27299 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Ramirez, Cole, E,13616 | 6872.06 | 0.00 | 0.00 | 2049.10 | 4822.96 |
| Shen, Willie, S,18450 | 25.48 | 0.00 | 0.00 | 0.00 | 25.48 |
| Raje, Bonnie,20629 | 6060.50 | 0.00 | 3578.27 | 0.00 | 2482.23 |
| Anand, Calvin, E,28717 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Chander, Cassie, M,18258 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Sanders, Devin, J,12014 | 3949.97 | 0.00 | 3399.99 | 0.00 | 549.98 |
| Madan, Martin, M,24911 | 102.96 | 0.00 | 0.00 | 0.00 | 102.96 |
| He, Dawn,15647 | 3764.07 | 0.00 | 0.00 | 2049.10 | 1714.97 |
| Garcia, Ruth,20623 | 6093.20 | 0.00 | 3578.27 | 0.00 | 2514.93 |
| Gonzalez, Francisco, L,12245 | 3967.26 | 0.00 | 3399.99 | 0.00 | 567.27 |
| Romero, Ricky,21361 | 2997.32 | 0.00 | 2443.35 | 0.00 | 553.97 |
| Liang, Gilbert,12242 | 3948.97 | 0.00 | 3374.99 | 0.00 | 573.98 |
| Shan, Deborah,20624 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Patel, Veronica,13963 | 74.48 | 0.00 | 0.00 | 0.00 | 74.48 |
| Ms., Rousey, Linda, R.,21279 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vance, Marco,13124 | 87.93 | 0.00 | 0.00 | 0.00 | 87.93 |
| Foster, Madison,14038 | 6819.12 | 0.00 | 0.00 | 2049.10 | 4770.02 |
| Rana, Pedro, F,13970 | 6843.14 | 0.00 | 0.00 | 2049.10 | 4794.04 |
| Liang, Lacey, A,15719 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| McDonald, Brent,14068 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Sara, Candace,21380 | 2735.53 | 0.00 | 2181.56 | 0.00 | 553.97 |
| Li, Gilbert,23999 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Pal, Alvin, C,29319 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 |
Generated 2025-11-03 20:53:44.239 UTC