formulae in Pivot Table

  • Thread starter Thread starter andreww
  • Start date Start date
A

andreww

Hi - I have a pivot report which is basically date_invoice_paid by
category_of_invoice with sales_value as the data item. I want to have
year(date_invoice_paid) and within that month(date_invoice_paid). I could
make another column in the excel sheet but wanted to know if there was some
way I could formularise it programtaically/otherwise.

Cheers

Andrew
 
If you have dates as one of your fields, look at the group capability of the
pivot table. You can group on year and month.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
Using VBA on Excel Pivot Tables 3
How I can set dynamic pivot table ONLY when I have enough data point 1
Playing back a Pivot Table macros 2
Link Drop Down list with Pivot Table 3
Link Drop Down list with PIVOT Table in Excel 2003 0
Pivot Table Question 2
Pivot table multiple filters 2

Back
Top