@Harshvardhan do you want to convert data from Data to Month? or only some data to month but some of them still keeping date?
if I refer to the above example, only Feb and Mar of 2023 will be converted to month but Apr and May still keeping date format in the same column?
@royyung I believe in this approach, I have to select date from date picker, the format will change but date will also be selected. Value of Cost will change with respect to date, for example if I choose start month - 01/02/2023 and end month - 09/04/2023, in filter these selections of date will be shown as YYYY/MM i.e start month - 02/2023 and end month - 04/2023, but in output table 4th month will not be shown as our data has value after 09/04/2023.
Am I missing something or this is the expected result from this filter.
Is there anyway to have same value in whole month, irrespective of the date that I select?