I have a Pivot table with several columns and two calculated fields. One field is Column J =((Sum(d2+e2+f2)*h2)+b2))/c2. The other calcuated field is column H and that just consists of Field =20%, In others words I have to multiple three columns by a constant, add to another column and divide the whole deal by another column.
This works fine until it was pointed out to me that some of the subsets in my rows really have a constant of 50%. These are small criteria and the overall effect is not great but I need to get it right.
How can I use two different multipliers in the same column? is this not worth pursuing?
Thank you to all
This works fine until it was pointed out to me that some of the subsets in my rows really have a constant of 50%. These are small criteria and the overall effect is not great but I need to get it right.
How can I use two different multipliers in the same column? is this not worth pursuing?
Thank you to all
