Go in the Health App on your iPhone. Tap Activity. . Tap the metric in which you are interested. Active Energy, Exercise, etc Tap MONTH. You might have to do some calculations with data listed.
Also, you can select "Today" at the bottom and the screen. Then select the date you wish to view. After you select the desired metric, you can also select MONTH or YEAR. Didn't think I needed to add that originally.
Alternately, you can tap on your User icon in the top right corner of the main screen in the Health app and select Export Health Data. You can email the ZIP file and when extracted, it will contain two XML files. You may or may not be able to do anything with the XML files.
Alternately, you can download an app named QS Access. You can use it to select the metrics you desire and export the data as a CSV which you can open in various programs (Excel, Notepad, etc) and manipulate the data there.