Peaklander
New member
- Joined
- Sep 23, 2015
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi all,
This is my first post (first posts are always questions aren't they?!)
I have a pivot of a large array of data (about 300,00 rows ). I'd like to perform an average calculation within the pivot (calculated field?) but I don't know how to determine the denominator. This would be the number of items that are getting through the filters. These are Period (1-13) Week (1-4) and Day (Sun - Sat). There could be as few as one item in there or as many as 13 x 4 x 7. The numerator is the sumof field in the pivot builder.
Could anyone explain if i can get this value and if so would I need to use it in a bit of VBA (which I could probably manage) or if it can be used within an Excel formula in a calculated field maybe.
I hope the question makes sense,
Thank you
This is my first post (first posts are always questions aren't they?!)
I have a pivot of a large array of data (about 300,00 rows ). I'd like to perform an average calculation within the pivot (calculated field?) but I don't know how to determine the denominator. This would be the number of items that are getting through the filters. These are Period (1-13) Week (1-4) and Day (Sun - Sat). There could be as few as one item in there or as many as 13 x 4 x 7. The numerator is the sumof field in the pivot builder.
Could anyone explain if i can get this value and if so would I need to use it in a bit of VBA (which I could probably manage) or if it can be used within an Excel formula in a calculated field maybe.
I hope the question makes sense,
Thank you