R
R Kumana
Hi, I have a problem using pivottables.
I have created one with orders as the rows and operations as the columns,
and volume as the data:
sumof sqft operation1 operation2 operation3
order1 1241 1212
order2 1021 999 879
order3 3412 3212
What I need to do is calculate something like:
sumif (operation3, operation 1>0)
sumif (operation3, operation 2>0)
and so on for each combination (there are about 5 operations). I am trying
to use GetPivotdata but I don't know how to use if statements in that
function. Can anyone help?
I have created one with orders as the rows and operations as the columns,
and volume as the data:
sumof sqft operation1 operation2 operation3
order1 1241 1212
order2 1021 999 879
order3 3412 3212
What I need to do is calculate something like:
sumif (operation3, operation 1>0)
sumif (operation3, operation 2>0)
and so on for each combination (there are about 5 operations). I am trying
to use GetPivotdata but I don't know how to use if statements in that
function. Can anyone help?