Nov 14 2019 07:24 PM
SolutionIt's not clear exactly what you are trying to achieve.
Is it possible for you to upload a sample file (not an image) to show us what you are trying to achieve?
Nov 14 2019 08:00 PM
Fund Long Name | Fund Short Name | Fund Account # |
Bergmann & Wayland Scholarship | BBAW | EN001088 |
BU General Financial Aid | BBUG | EN001089 |
BU General Financial Aid | BBUG | EN001090 |
BU General Financial Aid | BBUG | EN001091 |
Burton Scholarship | BBUR | EN001092 |
Fellows Program Renewable | BCF2 | EN001093 |
Fellows Program Renewable | BCF2 | EN001094 |
Fellows Program Renewable | BCF2 | EN001095 |
Fellows Program Renewable | BCF2 | EN001096 |
Fellows Program Renewable | BCF2 | EN001097 |
Fellows Program Renewable | BCF2 | EN001098 |
Fellows Program Renewable | BCF2 | EN001099 |
Peter Dix Memorial Scholarship | BDIK | EN001100 |
Carolyn & Patrick Dolan Scholarship | BDOL | EN001101 |
Robert & Christina Seix Dow Scholarship | BDW2 | EN001102 |
Sajjad Ebrahim '73 Scholarship Fund | BEBR | EN001103 |
Fellows - Laidlaw Merit Fund | BLW1 | EN001104 |
Lord Irvine A.S. Laidlaw Scholarship | BLW2 | EN001105 |
Lord Irvine A.S. Laidlaw Scholarship | BLW2 | EN001106 |
Lord Irvine A.S. Laidlaw Scholarship | BLW2 | EN001107 |
MBA Scholarship | BMBA | EN001108 |
MBA Scholarship | BMBA | EN001109 |
MBA Scholarship | BMBA | EN001110 |
MBA Scholarship | BMBA | EN001111 |
F.K. Tang Scholarship | BTNG | EN001112 |
The Financial Planning Office wants to know: 1) How much was spent on scholarship? 2) How much was spent on need vs. merit aid? ***(Note --use only account numbers) |
FYI: This is not school work or office work -- I am self-teaching myself how to use excel and Pivot tables and this is a sample and I need help with this?
Nov 14 2019 08:08 PM
There is no Spent Amount column in the data set. How are you going to figure that out?
Can you please mock up the desired output manually to show the end result you are trying to achieve based on the data in the sample file?
Nov 14 2019 08:37 PM
Nov 14 2019 10:35 PM
Please have a look at the Pivot Table inserted on the Master Sheet and let me know if that is what you are trying to achieve.
Before inserting the Pivot Table, I converted the data range on Master Sheet into an Excel Table and named it "FundData" so that if you add/delete data in the Table, Pivot Table will be updated after being refreshed.
Nov 14 2019 07:24 PM
SolutionIt's not clear exactly what you are trying to achieve.
Is it possible for you to upload a sample file (not an image) to show us what you are trying to achieve?