| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Customer Code | CampaignID | End Date | Start Date | MEASURES TO CALCULATE SALES VOLUME BETWEEN START & END DATE | ||
2 | 10000606 | HD.03.12.2300.11519 | 9/30/2022 | 10/1/2020 | sumif( 'sale amount' , date between campaign's start & end date) | ||
3 | 10000610 | HD.03.12.2500.16922 | 6/30/2023 | 7/15/2021 | |||
4 | 10000611 | HD.03.12.2500.12506 | 9/30/2022 | 10/1/2020 | |||
5 | 10000612 | HD.03.12.2600.11308 | 9/30/2022 | 10/1/2020 | |||
6 | 10000613 | HD.03.12.2500.17080 | 8/31/2023 | 8/9/2021 | |||
7 | 10000614 | HD.03.12.2500.12719 | 9/30/2022 | 10/1/2020 | |||
8 | 10000619 | HD.03.12.2500.12974 | 9/30/2022 | 10/1/2020 | |||
9 | 10000626 | HD.03.12.2600.10952 | 9/30/2022 | 10/1/2020 | |||
10 | 10000628 | HD.03.12.2500.12979 | 9/30/2022 | 10/1/2020 | |||
11 | 10000629 | HD.03.12.2600.11264 | 9/30/2022 | 10/1/2020 | |||
12 | 10000631 | HD.03.12.2500.13044 | 9/30/2022 | 10/1/2020 | |||
13 | 10000632 | HD.03.12.2500.16902 | 6/30/2023 | 7/15/2021 | |||
14 | 10000634 | HD.03.12.2600.10967 | 9/30/2022 | 10/1/2020 | |||
15 | 10000635 | HD.03.12.2500.12897 | 9/30/2022 | 10/1/2020 | |||
16 | 10000638 | HD.03.12.2600.17434 | 9/30/2023 | 10/13/2021 | |||
17 | 10000641 | HD.03.12.2600.13864 | 9/30/2022 | 10/1/2020 | |||
18 | 10000643 | HD.03.12.2600.12957 | 9/30/2022 | 10/1/2020 | |||
19 | 10000647 | HD.03.12.2500.12986 | 9/30/2022 | 10/1/2020 | |||
20 | 10000649 | HD.03.12.2500.13007 | 9/30/2022 | 10/1/2020 | |||
21 | 10000654 | HD.03.12.2500.17045 | 7/31/2023 | 8/1/2021 | |||
22 | 10000659 | HD.03.12.2600.12742 | 9/30/2022 | 10/1/2020 | |||
23 | 10000662 | HD.03.12.2500.16908 | 6/30/2023 | 7/15/2021 | |||
24 | 10000664 | HD.03.12.2500.12808 | 9/30/2022 | 10/1/2020 | |||
25 | 10000668 | HD.03.12.2600.12578 | 9/30/2022 | 10/1/2020 | |||
26 | 10000670 | HD.03.12.2500.16898 | 6/30/2023 | 7/15/2021 | |||
27 | 10000671 | HD.03.12.2500.12715 | 9/30/2022 | 10/1/2020 | |||
28 | 10000672 | HD.03.12.2500.12955 | 9/30/2022 | 10/1/2020 | |||
29 | 10000673 | HD.03.12.2500.16921 | 6/30/2023 | 7/15/2021 | |||
30 | 10000674 | HD.03.12.2500.12975 | 9/30/2022 | 10/1/2020 | |||
31 | 10000676 | HD.03.12.2500.12414 | 9/30/2022 | 10/1/2020 | |||
32 | 10000677 | HD.03.12.2500.12962 | 9/30/2022 | 10/1/2020 | |||
33 | 10000678 | HD.03.12.2500.12958 | 9/30/2022 | 10/1/2020 | |||
34 | 10000682 | HD.03.12.2600.13842 | 9/30/2022 | 10/1/2020 | |||
35 | 10000685 | HD.03.12.2500.17039 | 7/31/2023 | 8/1/2021 | |||
36 | 10000687 | HD.03.12.2600.13837 | 9/30/2022 | 10/1/2020 | |||
37 | 10000689 | HD.03.12.2500.12984 | 9/30/2022 | 10/1/2020 | |||
38 | 10000692 | HD.03.12.2500.10144 | 7/31/2022 | 8/1/2020 | |||
39 | 10000696 | HD.03.12.2500.13036 | 9/30/2022 | 10/1/2020 | |||
40 | 10000700 | HD.03.12.2500.12951 | 9/30/2022 | 10/1/2020 | |||
41 | 10000712 | HD.03.12.2600.12758 | 9/30/2022 | 10/1/2020 | |||
42 | 10000717 | HD.03.12.2600.10832 | 9/30/2022 | 10/1/2020 | |||
43 | 10000719 | HD.03.12.2600.12568 | 9/30/2022 | 10/1/2020 | |||
44 | 10000720 | HD.03.12.2600.12689 | 9/30/2022 | 10/1/2020 | |||
45 | 10000721 | HD.03.12.2600.12685 | 9/30/2022 | 10/1/2020 | |||
46 | 10000724 | HD.03.12.2600.10999 | 9/30/2022 | 10/1/2020 | |||
47 | 10000725 | HD.03.12.2600.10825 | 9/30/2022 | 10/1/2020 | |||
48 | 10000736 | HD.03.12.2500.12516 | 9/30/2022 | 10/1/2020 | |||
49 | 10000737 | HD.03.12.2600.14138 | 10/31/2022 | 11/1/2020 | |||
50 | 10000742 | HD.03.12.2600.13814 | 9/30/2022 | 10/1/2020 | |||
51 | 10000744 | HD.03.12.2600.12410 | 9/30/2022 | 10/1/2020 | |||
52 | 10000746 | HD.03.11.2600.2048 | 6/30/2022 | 7/1/2019 | |||
53 | 10000748 | HD.03.12.2600.10817 | 9/30/2022 | 10/1/2020 | |||
54 | 10000756 | HD.03.12.2600.12357 | 9/30/2022 | 10/1/2020 | |||
55 | 10000758 | HD.03.12.2600.11207 | 9/30/2022 | 10/1/2020 | |||
56 | 10000762 | HD.03.12.2600.10979 | 9/30/2022 | 10/1/2020 | |||
57 | 10000763 | HD.03.12.2500.16931 | 6/30/2023 | 7/15/2021 | |||
58 | 10000765 | HD.03.12.2600.10981 | 9/30/2022 | 10/1/2020 | |||
59 | 10000776 | HD.03.12.2500.16905 | 6/30/2023 | 7/15/2021 | |||
60 | 10000781 | HD.03.12.2500.16850 | 7/31/2023 | 7/9/2021 | |||
61 | 10000782 | HD.03.12.2500.10380 | 9/30/2022 | 10/1/2020 | |||
62 | 10000784 | HD.03.12.2600.12526 | 9/30/2022 | 10/1/2020 | |||
63 | 10000794 | HD.03.12.2600.10991 | 9/30/2022 | 10/1/2020 | |||
64 | 10000798 | HD.03.12.2600.10998 | 9/30/2022 | 10/1/2020 | |||
65 | 10000808 | HD.03.12.2600.13807 | 9/30/2022 | 10/1/2020 | |||
66 | 10000810 | HD.03.12.2500.17046 | 7/31/2023 | 8/1/2021 | |||
67 | 10000813 | HD.03.12.2600.11367 | 9/30/2022 | 10/1/2020 | |||
68 | 10000818 | HD.03.12.2600.17545 | 10/31/2023 | 11/1/2021 | |||
69 | 10000832 | HD.03.12.2600.11002 | 9/30/2022 | 10/1/2020 | |||
70 | 10000833 | HD.03.12.2600.11222 | 9/30/2022 | 10/1/2020 | |||
71 | 10000836 | HD.03.12.2600.14115 | 9/30/2022 | 10/1/2020 | |||
72 | 10000838 | HD.03.12.2600.11003 | 9/30/2022 | 10/1/2020 | |||
73 | 10000840 | HD.03.11.2600.2047 | 5/31/2022 | 6/1/2019 | |||
74 | 10000844 | HD.03.12.2600.11004 | 9/30/2022 | 10/1/2020 | |||
75 | 10000852 | HD.03.12.2600.12764 | 9/30/2022 | 10/1/2020 | |||
76 | 10000853 | HD.03.12.2600.14293 | 9/30/2022 | 10/1/2020 | |||
77 | 10000858 | HD.03.12.2500.13008 | 9/30/2022 | 10/1/2020 | |||
78 | 10000864 | HD.03.12.2600.10828 | 9/30/2022 | 10/1/2020 | |||
79 | 10000873 | HD.03.12.2600.12796 | 9/30/2022 | 10/1/2020 | |||
80 | 10000877 | HD.03.12.2500.17484 | 10/31/2023 | 11/1/2021 | |||
81 | 10000880 | HD.03.12.2600.10774 | 9/30/2022 | 10/1/2020 | |||
82 | 10000886 | HD.03.12.2600.12767 | 9/30/2022 | 10/1/2020 | |||
83 | 10000888 | HD.03.12.2500.12945 | 9/30/2022 | 10/1/2020 | |||
84 | 10000889 | HD.03.12.2500.16925 | 6/30/2023 | 7/15/2021 | |||
85 | 10000890 | HD.03.12.2600.11000 | 9/30/2022 | 10/1/2020 | |||
86 | 10000891 | HD.03.12.2500.16958 | 7/31/2023 | 7/20/2021 | |||
87 | 10000892 | HD.03.12.2600.11005 | 9/30/2022 | 10/1/2020 | |||
88 | 10000893 | HD.03.12.2600.11006 | 9/30/2022 | 10/1/2020 | |||
89 | 10000894 | HD.03.12.2600.13636 | 9/30/2022 | 10/1/2020 | |||
90 | 10000895 | HD.03.12.2500.16926 | 6/30/2023 | 7/15/2021 | |||
91 | 10000898 | HD.03.12.2600.11365 | 9/30/2022 | 10/1/2020 | |||
92 | 10000918 | HD.03.12.2600.10866 | 9/30/2022 | 10/1/2020 | |||
93 | 10000919 | HD.03.12.2600.10882 | 9/30/2022 | 10/1/2020 | |||
94 | 10000920 | HD.03.12.2600.10867 | 9/30/2022 | 10/1/2020 | |||
95 | 10000922 | HD.03.12.2600.16437 | 4/30/2023 | 5/9/2021 | |||
96 | 10000925 | HD.03.12.2600.13777 | 9/30/2022 | 10/1/2020 | |||
97 | 10000927 | HD.03.12.2600.12009 | 9/30/2022 | 10/1/2020 | |||
98 | 10000928 | HD.03.12.2600.10973 | 9/30/2022 | 10/1/2020 | |||
99 | 10000933 | HD.03.12.2600.12823 | 9/30/2022 | 10/1/2020 | |||
100 | 10000935 | HD.03.12.2500.15673 | 1/31/2023 | 2/1/2021 |