[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'CAD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 23 < SKIP 251 > < TAKE 62 >
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Rowe, Todd,14586 | 233.94 | 0.00 | 0.00 | 0.00 | 233.94 |
| Washington, Lauren, R,22998 | 5329.25 | 0.00 | 3578.27 | 1750.98 | 0.00 |
| Peterson, Xavier, R,26456 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Hill, Carlos,12919 | 257.88 | 0.00 | 0.00 | 0.00 | 257.88 |
| Young, Kaylee, S,13756 | 298.49 | 0.00 | 0.00 | 0.00 | 298.49 |
| Scott, Adam,15863 | 243.01 | 0.00 | 0.00 | 0.00 | 243.01 |
| Suarez, Juan, R,16763 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Simmons, Sarah, V,11500 | 651.98 | 0.00 | 0.00 | 34.99 | 616.99 |
| Phillips, Kaylee,21138 | 4371.38 | 0.00 | 0.00 | 2049.10 | 2322.28 |
| Hughes, Destiny, P,28027 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Shan, Gabriel, T,27731 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Perry, James,19205 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Simmons, Mariah,26683 | 1270.82 | 0.00 | 699.10 | 0.00 | 571.72 |
| Jai, Edwin,16921 | 1754.98 | 0.00 | 0.00 | 0.00 | 1754.98 |
| Wood, Gavin,16964 | 108.54 | 0.00 | 0.00 | 21.98 | 86.56 |
| Long, Sydney,27921 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Ramirez, Brian, M,11618 | 2369.96 | 0.00 | 0.00 | 0.00 | 2369.96 |
| Yuan, Leonard, F,16791 | 1729.97 | 0.00 | 0.00 | 0.00 | 1729.97 |
| King, Sara,22354 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bennett, Antonio, C,11631 | 707.50 | 0.00 | 0.00 | 0.00 | 707.50 |
| Torres, Dalton,23503 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rivera, Caitlin, L,26113 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Hernandez, Eduardo, J,18919 | 300.94 | 0.00 | 0.00 | 0.00 | 300.94 |
| Bennett, Isabelle, C,18674 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Sanchez, Caitlin, M,22080 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Cox, Nathaniel, A,19661 | 2521.27 | 0.00 | 0.00 | 0.00 | 2521.27 |
| Lewis, Kaitlyn,15906 | 4761.03 | 0.00 | 0.00 | 0.00 | 4761.03 |
| Allen, Sean, L,12097 | 159.22 | 0.00 | 0.00 | 0.00 | 159.22 |
| Stewart, Brooke, R,24759 | 4369.59 | 0.00 | 3578.27 | 0.00 | 791.32 |
| Sanchez, Faith,27049 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Reed, Erin, I,14353 | 128.84 | 0.00 | 0.00 | 0.00 | 128.84 |
| Srini, Ruben,18078 | 200.94 | 0.00 | 0.00 | 0.00 | 200.94 |
| Wang, Austin, A,14632 | 84.97 | 0.00 | 0.00 | 0.00 | 84.97 |
| Price, Riley, R,13909 | 4764.02 | 0.00 | 0.00 | 0.00 | 4764.02 |
| Patterson, Abigail, H,14478 | 4795.01 | 0.00 | 0.00 | 0.00 | 4795.01 |
| Gonzales, Miranda,11660 | 324.72 | 0.00 | 0.00 | 0.00 | 324.72 |
| Thompson, Kaitlyn, L,12430 | 223.93 | 0.00 | 0.00 | 0.00 | 223.93 |
| Foster, Olivia,23806 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Campbell, Wyatt, C,27602 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Martin, Jeremiah, E,17345 | 1764.96 | 0.00 | 0.00 | 0.00 | 1764.96 |
| Adams, Jennifer,15362 | 4745.02 | 0.00 | 0.00 | 0.00 | 4745.02 |
| Russell, Arianna,22728 | 149.93 | 0.00 | 0.00 | 0.00 | 149.93 |
| Perry, Dalton, A,16149 | 192.04 | 0.00 | 0.00 | 0.00 | 192.04 |
| Thomas, Emily,21803 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Robinson, Ian, D,13852 | 2294.99 | 0.00 | 0.00 | 0.00 | 2294.99 |
| Thames, Bernard,23803 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Jones, Charles,22882 | 101.45 | 0.00 | 0.00 | 0.00 | 101.45 |
| Carter, Jonathan,14578 | 848.47 | 0.00 | 0.00 | 0.00 | 848.47 |
| Diaz, Angela, K,27259 | 782.99 | 0.00 | 0.00 | 782.99 | 0.00 |
| Wright, Robert, C,15889 | 4848.03 | 0.00 | 0.00 | 0.00 | 4848.03 |
| Powell, Jocelyn, A,21658 | 2641.89 | 0.00 | 0.00 | 2071.42 | 570.47 |
| Parker, Madeline, H,22182 | 6006.32 | 0.00 | 3578.27 | 0.00 | 2428.05 |
| Richardson, Melissa, E,11132 | 2371.94 | 0.00 | 0.00 | 0.00 | 2371.94 |
| Zeng, Jake,18054 | 106.93 | 0.00 | 0.00 | 0.00 | 106.93 |
| Davis, Dylan,15556 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Richardson, Olivia,20468 | 3169.59 | 0.00 | 0.00 | 2049.10 | 1120.49 |
| Richardson, Evan, J,15488 | 165.30 | 0.00 | 0.00 | 0.00 | 165.30 |
| Taylor, Madison, A,11802 | 215.29 | 0.00 | 0.00 | 0.00 | 215.29 |
| Garcia, Carmen, J,24781 | 2181.56 | 0.00 | 2181.56 | 0.00 | 0.00 |
| Cannata, Gabrielle, C,21725 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yang, Jordan, K,14458 | 133.95 | 0.00 | 0.00 | 0.00 | 133.95 |
| Russell, Rachel, C,21581 | 24.27 | 0.00 | 0.00 | 0.00 | 24.27 |
Generated 2025-12-24 05:58:41.233 UTC