Hi Friends,
I have a question on Pivot tables, please can anyone let me know if it is possible to add a formula to pivot table.
I have almost 6 pivots looking at the same data source but picking up information based on month and week.
I would like to know if it is possible to enter a formula in pivot to pickup this information (that is the month) from another sheet and update the pivots as per this items.
Thanks
Bookmarks