Sumif Formula Based on Pivottable
All,
I am trying to create a sumifs fomula on a pivot table which takes the sum of all revenues with a probability >50.
I do not want to use the normal sumifs as I want the possiblity to change my dataset, the pivot table and there is some content below as well.
Is there a possiblity to create this formula with a GETPIVOTDATA somehow?
Find what I mean in attachment.
Thanks.
Hi and welcome to the forum.
I don't see why you are unwilling to use the PT data. It's also bad practice to use cells below or to the right of a PT since inevitably a new pivot view can easily compromise those cells.
A PT can't give you any better information than a SUMIFS analysis of the original data. One thing you should ensure is that you use dynamic range names todefine your data so that as it gets bigger the range name automatically adjusts.
If you really want to use the PT then why not add a Slicer that uses the Probability fleld to filter the PT?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks