Calculating QTD with multiple years data

[Megha1484]

Hi Everyone,
I need some help in calculating QTD for mutilple years, months and dates, please see the table below. My actual sheet will have data from 2018 to future years by each month. And each month could have multiple dates in it, like shown in the sample data. I would like to display the result as shown in the sample data right below under "pivot results" Is there a way to do it the way I want it? Any help would be greatly appreciated. I hope I was clear enough. If not, please let me know and I will try to explain it in detail.

Thanks!!!
date month year values QTD
1/5/2018 1 2018 1
1/14/2018 1 2018 2
1/16/2018 1 2018 1
2/3/2018 2 2018 3
2/6/2018 2 2018 4
3/5/2018 3 2018 5 16
1/5/2019 1 2019 1
1/14/2019 1 2019 2
1/16/2019 1 2019 3
2/3/2019 2 2019 4
2/6/2019 2 2019 5
3/5/2019 3 2019 1 16



pivot results
QT. QTD total
Q1 2018 16
Q1 2019 16

 

[Megha1484]

Sorry, the data got all messed up when I copied it from Excel. Here is the better version if it.


date month year total QTD Total
1/5/2018 1 2018 1
1/14/2018 1 2018 2
1/16/2018 1 2018 1
2/3/2018 2 2018 3
2/6/2018 2 2018 4
3/5/2018 3 2018 5 16
1/5/2019 1 2019 1
1/14/2019 1 2019 2
1/16/2019 1 2019 3
2/3/2019 2 2019 4
2/6/2019 2 2019 5
3/5/2019 3 2019 1 16



pivot results
QTYear QTD total
Q1 2018. 16
Q1 2019 16