I am looking to create a calculated field where a sum of column A is multiplied by a min of column B. What seems to be happening instead is simply a multiplication of a sum of both columns.
So:
So, what I want![]()
Column A | Column B 123 .97 456 .97 789 .97 123 .94 456 .95 789 .93
2736 * .93
What seems to be happening
2736 * 5.73
My formula in the calculated field is
How can I get the result I want in a Pivot Table?![]()
=Sum('Column A') * Min('Column B')
Bookmarks