Armand2706
New Member
- Joined
- Nov 12, 2020
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hello everyone!
I'm using Power Pivot for data analysis and I was wondering how I could build a pivot table to do the following:
1) that will look at a certain data set and see if on average it is performed on a yearly, quarterly or monthly basis - For example I'm looking at account reconciliations and I'm trying to see if a person performs those reconciliations on average on a yearly, quarterly or monthly basis and
2) compare the result in 1) to another data set - In my example, it will compare the results in 1) to a certain policy that will list the account numbers and the frequency required for the reconciliations to be performed.
Thank you for your help!
Armand
I'm using Power Pivot for data analysis and I was wondering how I could build a pivot table to do the following:
1) that will look at a certain data set and see if on average it is performed on a yearly, quarterly or monthly basis - For example I'm looking at account reconciliations and I'm trying to see if a person performs those reconciliations on average on a yearly, quarterly or monthly basis and
2) compare the result in 1) to another data set - In my example, it will compare the results in 1) to a certain policy that will list the account numbers and the frequency required for the reconciliations to be performed.
Thank you for your help!
Armand
