MegastarMagus
New Member
- Joined
- Aug 3, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I create a lot of what I believe are very simple Pivot Tables using a lot of different data sources. I am not experienced in the PowerExcel/PowerPivot options.
Each of my Pivot Tables is comprised of different amounts and complexities of data and have different Record/Field names.
My issue is with having to change the Field Settings from Subtotals/Automatic to Subtotals/None.
I understand that a Book Template can be created for the style of the Pivot Table (I watched video 2405!), but can the Field Setting be set in that Template?
Is there a macro that can be run to make the Field Settings change to a default value at the start of every Pivot Table?
Thanks, in advance!
Data:
Table created
Each of my Pivot Tables is comprised of different amounts and complexities of data and have different Record/Field names.
My issue is with having to change the Field Settings from Subtotals/Automatic to Subtotals/None.
I understand that a Book Template can be created for the style of the Pivot Table (I watched video 2405!), but can the Field Setting be set in that Template?
Is there a macro that can be run to make the Field Settings change to a default value at the start of every Pivot Table?
Thanks, in advance!
Data:
Interim - Aug 3 - DSC04300-63rd 01-03 1831- GenScriber 2021-08-02.xlsx | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
1 | Regimental Number | Rank | Lastname | Firstname | Period-from-year | Period-from-month | Period-from-day | Period-to-year | Period-to-month | Period-to-day | 2s7d per diem | 2s1d per diem | 1s11d per diem | 1s5d per diem | Days on board Ship | Reason - 1st Muster | ||
2 | 143 | Sergeant | Mackey | Edward | 1831 | 4 | 1 | 1831 | 6 | 30 | 90 | |||||||
3 | 143 | Sergeant | Mackey | Edward | 1831 | 4 | 1 | 1831 | 6 | 30 | 90 | |||||||
4 | 143 | Sergeant | Mackey | Edward | 1831 | 4 | 1 | 1831 | 6 | 30 | 90 | |||||||
5 | 143 | Sergeant | Mackey | Edward | 1831 | 4 | 1 | 1831 | 6 | 30 | 90 | |||||||
6 | 143 | Sergeant | Mackey | Edward | 1831 | 7 | 1 | 1831 | 9 | 30 | 92 | On Guard | ||||||
7 | 143 | Sergeant | Mackey | Edward | 1831 | 10 | 1 | 1831 | 12 | 31 | 92 | On Guard | ||||||
8 | 143 | Sergeant | Mackey | Edward | 1831 | 10 | 1 | 1831 | 12 | 31 | 92 | On Guard | ||||||
9 | 143 | Sergeant | Mackey | Edward | 1832 | 1 | 1 | 1832 | 3 | 31 | 91 | On Guard | ||||||
10 | 143 | Sergeant | Mackey | Edward | 1832 | 4 | 1 | 1832 | 6 | 30 | 91 | Eagle Hawk Neck | ||||||
11 | 143 | Sergeant | Mackey | Edward | 1832 | 7 | 1 | 1832 | 9 | 30 | 92 | |||||||
12 | 143 | Sergeant | Mackey | Edward | 1832 | 10 | 1 | 1832 | 12 | 31 | 92 | On Guard | ||||||
13 | 143 | Sergeant | Mackey | Edward | 1833 | 1 | 1 | 1833 | 3 | 31 | 90 | On Guard | ||||||
14 | 143 | Sergeant | Mackey | Edward | 1833 | 4 | 1 | 1833 | 6 | 30 | 91 | |||||||
15 | 143 | Sergeant | Mackey | Edward | 1833 | 7 | 1 | 1833 | 9 | 30 | 92 | |||||||
16 | 143 | Sergeant | Mackey | Edward | 1833 | 10 | 1 | 1833 | 12 | 31 | 83 | |||||||
17 | 143 | Sergeant | Mackey | Edward | 1834 | 1 | 1 | 1834 | 3 | 31 | on Board ISABELLA | |||||||
DSC04300-63rd 01-03 1831- GenSc |
Table created
Period-from-year | Lastname | Firstname | Rank |
1831 | Mackey | Edward | Sergeant |
1832 | Mackey | Edward | Sergeant |
1833 | Mackey | Edward | Sergeant |
1834 | Mackey | Edward | Sergeant |
1838 | Mackey | Edward | Private |
1839 | Mackey | Edward | Private |
1840 | Mackey | Edward | Private |
Grand Total | |||