I need to make a dropdown list or filter where the columns of "YTD / Month" shall present value of the cumulative month or the month the user selects.
Just above should have an option to select "Cumulative" or "Month" and another option of selecting one of the months of the year.
YTD: should add up all the months of January to the option selected in all versions shown in month column layout.
Month: should bring the balance of the month selected in the column option for all versions shown in layout.
Is there any formula epm? Or suggestion to create the excel?