Hello All, is there any way to create a calculated field that can be used in a pivot table to act as month-by-month column?
I’ve been instructed to create a pivot with rows of data using various different dates of interest (i.e. date opened, date closed, date contact made, etc.,) which I want to display within one table.
Thanks
Hello @hopeah,
Initially, select the pivot table. Then, click on the dates you want to focus on. After that, go to the format visual option and choose the pivot settings as shown in the attached snapshot. If you need any additional information, feel free to reach out.
Hi @Vaibhav.narwade, sorry, I don’t think I explained myself very well.
Ideally, I need a pivot table with columns for each month that is not dependent of the data in the rows.
