As an example, please take a look at the image below. I need to create a pivot table with three columns: Name, Total, and Monthly. However, I need help with the monthly filter. Let's say, When I click on monthly, I should be able to select a date from a list. Also able to filter monthly, quarterly and yearly. Please only do if you know this! and let me know if you have questions.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
As an example, please take a look at the image below. I need to create a pivot table with three columns: Name, Total, and Monthly. However, I need help with the monthly filter. Let's say, When I click on monthly, I should be able to select a date from a list. Also able to filter monthly, quarterly and yearly. Please only do if you know this! and let me know if you have questions. 
D
E
G
H
M
N
1/1/2022 2/1/2022 3/1/2022 4/1/2022 5/1/2022 6/1/2022 7/1/2022 8/1/2022 9/1/2022 10/1/2022 11/1/2022 12/1/2022 1/1/2023
343
Name
Total
76
298
Harry
90
787
87
98
8
87
878
87
69
79
98
9
2984
345
Sam
98
3984
3974
2983
27
2842
2039
28
29
2397
283
237
Andrew
77
232
98
97
86
7
6
97
9
8
13
87
Name
- Total
Monthly
Andrew
77
232
Harry
90
343
Sam
98
3984
Grand Tota
265
4559
Transcribed Image Text:D E G H M N 1/1/2022 2/1/2022 3/1/2022 4/1/2022 5/1/2022 6/1/2022 7/1/2022 8/1/2022 9/1/2022 10/1/2022 11/1/2022 12/1/2022 1/1/2023 343 Name Total 76 298 Harry 90 787 87 98 8 87 878 87 69 79 98 9 2984 345 Sam 98 3984 3974 2983 27 2842 2039 28 29 2397 283 237 Andrew 77 232 98 97 86 7 6 97 9 8 13 87 Name - Total Monthly Andrew 77 232 Harry 90 343 Sam 98 3984 Grand Tota 265 4559
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman