[libreoffice-users] Pivot Tables - Monthly subtotals

Hello,

I have data like the following:

Transaction Date | Object | Transaction
2021-01-01 | Car | Bought
2021-03-01 | Car | Bought
2021-03-15 | Truck | Bought
2021-03-16 | Car | Bought
2021-03-18 | Car | Sold
2021-04-01 | Truck | Sold

I want to create a pivot table with Transaction Date as columns, Object 
as rows, and counts of Transaction as data fields . However, I do not 
want individual dates as columns, I want to look at the data by month. 
In other words, instead of this:

Object | 2021-01-01 | 2021-03-01 | 2021-03-15 | 2021-03-16 | 2021-03-18 
| 2021-04-01
Car | 1 | 1 | 0 | 1 | 1 |
Truck | 0 | 0 | 1 | 0 | 0 | 1

I want this:

Object | January | February | March | April

Car | 1 | 0 | 3 | 0

Truck | 0 | 0 | 1 | 1

How do I do this in LibreOffice Calc?

Julian
--

Julian So, B.Sc.,
Director of Quality Assurance
Immuni T
5th floor, suite SB-5180
141 President-Kennedy Avenue
Montreal QC, H2X 1Y4
514 545 3097 x105 Office
514 545 3064 Fax

Confidentialité:
Ce courrier électronique est confidentiel et protégé. Toute
diffusion, utilisation ou copie de ce message ou des renseignements
qu'il contient par une personne autre que le (les) destinataire(s)
désigné(s) est interdite. Si vous recevez ce courrier électronique
par erreur, veuillez informer l'expéditeur par courriel immédiatement
et effacer ce message et en détruire toute copie.

Confidentiality:
This message is confidential and privileged. Any distribution, use or
copying of this e-mail or the information it contains by other than
an intended recipient is unauthorized. If you are not the addressee,
please inform the sender by return e-mail immediately and delete this
message and destroy all copies.


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy