D
Dave
This solution is not perfect, but it might work for you.
What I would do is this: I'd add a column to your source
data which is a formula applied to your wh soh, which
says, "Only count my wh soh if I am the first occurrence
of this sku no. Otherwise leave me blank" That way you
dont need the max function, you'll just use the sum
function. The pivottable will likewise not show the max
number for every occurrence of the sku no, just the 1st
one.
If your range of source data is a1:f8(with labels in row
1), the sku column is Column B, and the wh soh column is
Column f, then the formula should go into g2(with a label
in g1 like "revised wh soh") and read, "=IF(COUNTIF
($B$1:B1,B2)>0,0,F2)"[copy down].
Then,
simply make your pivot table look at the revised column
instead of the original, and use sum in the output.
hth,
Dave
What I would do is this: I'd add a column to your source
data which is a formula applied to your wh soh, which
says, "Only count my wh soh if I am the first occurrence
of this sku no. Otherwise leave me blank" That way you
dont need the max function, you'll just use the sum
function. The pivottable will likewise not show the max
number for every occurrence of the sku no, just the 1st
one.
If your range of source data is a1:f8(with labels in row
1), the sku column is Column B, and the wh soh column is
Column f, then the formula should go into g2(with a label
in g1 like "revised wh soh") and read, "=IF(COUNTIF
($B$1:B1,B2)>0,0,F2)"[copy down].
Then,
simply make your pivot table look at the revised column
instead of the original, and use sum in the output.
hth,
Dave