When I have one date field in my data, I make that the COLUMN for the pivot table and group by year, month or quarter. But what if I have 2 date columns. Basically a date range (from and to dates) that I need to make as my COLUMN. Can you please let me know how I can achieve this?
from date to date amount
1/1/2019 2/2/2019 450
I am not sure which date field to use as column in this case. I cannot use just from date as I will miss out Feb month in the pivot grid.