Hello
I have a table with Unit Numbers, Unit Value and then 11 columns for 11 Financial Quarters showing Money received against that unit in each quarter. (Sample sheet attached for your reference) and then total of money received against that unit in all quarters.
I am trying to create something that will enable me to select the end date (i.e. a Financial Quarter) for the total money received till end of that quarter.
At the moment I am thinking of creating a drop down showing header for each column i.e. Quarter Names. I want to be able to select a "Quarter" from the drop down list and in the total column it should show a total of ALL the columns till the selected column from drop down.
For example I have following quarters in my sheet and also in drop down:
1) Q2-2022.23
2) Q3-2022.23
3) Q4-2022.23
4) Q1-2023.24
5) Q2-2023.24
6) Q3-2023.24
7) Q4-2023.24
8) Q1-2024.25
9) Q2-2024.25
10)Q3-2024.25
11) Q4-2024.25
If I select "Q3-2023.24" from dropdown list, then I want it to show total of values in each row in table shown under
Q2-2022.23 + Q3-2022.23 + Q4-2022.23 + Q1-2023.24 + Q2-2023.24 + Q3-2023.24
I hope I am not too confusing
Thanks
I have a table with Unit Numbers, Unit Value and then 11 columns for 11 Financial Quarters showing Money received against that unit in each quarter. (Sample sheet attached for your reference) and then total of money received against that unit in all quarters.
I am trying to create something that will enable me to select the end date (i.e. a Financial Quarter) for the total money received till end of that quarter.
At the moment I am thinking of creating a drop down showing header for each column i.e. Quarter Names. I want to be able to select a "Quarter" from the drop down list and in the total column it should show a total of ALL the columns till the selected column from drop down.
| Upto Quarter | |||||||||||||||
| Q2-2022.23 | Q3-2022.23 | Q4-2022.23 | Q1-2023.24 | Q2-2023.24 | Q3-2023.24 | Q4-2023.24 | Q1-2024.25 | Q2-2024.25 | Q4-2024.25 | ||||||
| Sr No | Unit no | Unit considertaion | Received amount Till Q2 - FY2022-23 (30.09.2022) | Received amount Till Q3 - FY2022-23 (31.12.2022) | Received amount Till Q4 - FY2022-23 (31.03.2023) | Received amount Till Q1 - FY2023-24 (30.06.2023) | Received amount Till Q2 - FY2023-24 (30.09.2023) | Received amount Till Q3 - FY2023-24 (31.12.2023) | Received amount Till Q4 - FY2023-24 (31.03.2024) | Received amount Till Q1 - FY2024-25 (30.06.2024) | Received amount Till Q2 - FY2024-25 (30.09.2024) | Received amount Till Q3 - FY2024-25 (31.12.2024) | Received amount Till Q4 - FY2024-25 (31.03.2025) | Total Received Till Date | |
| 1 | B-101 | 50,05,000 | 23,80,953 | 6,50,000 | 8,50,000 | 6,30,000 | 45,10,953 | ||||||||
| 2 | B-102 | 15,000 | 6,50,000 | 6,65,000 | |||||||||||
| 3 | B-103 | 78,00,000 | 0 | 3,50,000 | 9,20,000 | 1,05,000 | 9,90,000 | 23,65,000 | |||||||
| 4 | B-104 | 96,80,000 | 29,47,434 | 6,06,000 | 3,21,000 | 2,75,000 | 41,49,434 | ||||||||
| 5 | B-105 | 66,84,200 | 22,58,312 | 3,65,000 | 4,40,000 | 30,63,312 |
For example I have following quarters in my sheet and also in drop down:
1) Q2-2022.23
2) Q3-2022.23
3) Q4-2022.23
4) Q1-2023.24
5) Q2-2023.24
6) Q3-2023.24
7) Q4-2023.24
8) Q1-2024.25
9) Q2-2024.25
10)Q3-2024.25
11) Q4-2024.25
If I select "Q3-2023.24" from dropdown list, then I want it to show total of values in each row in table shown under
Q2-2022.23 + Q3-2022.23 + Q4-2022.23 + Q1-2023.24 + Q2-2023.24 + Q3-2023.24
I hope I am not too confusing
Thanks
