On a Pivot Table across the columns I have a field called "ACT Type." This field has 3 values, Labor, ODC and Excess.
Under the values I have two fields: Amount and Qty.
The amount values under Labor, ODC and Excess do appear which is good.
However, when I add the field Qty. under value, I get the Qty. showing under Labor, ODC and Qty, which I do not want. Instead of displaying the Qty. under Labor, ODC and Qty, I only want to display the Qty. values under the column called Labor.
Is it possible to filter out the Qty values and prevent them from being included under the ODC and Excess columns?
I have tried tabular format and other things, but to no avail. I also tried a calculated field where I defined a formula as =If(ACT Type = "LABOR",Qty,0) and this didn't work either. I got calculated columns under Labor, ODC and Excess, instead of only under Labor.
Under the values I have two fields: Amount and Qty.
The amount values under Labor, ODC and Excess do appear which is good.
However, when I add the field Qty. under value, I get the Qty. showing under Labor, ODC and Qty, which I do not want. Instead of displaying the Qty. under Labor, ODC and Qty, I only want to display the Qty. values under the column called Labor.
Is it possible to filter out the Qty values and prevent them from being included under the ODC and Excess columns?
I have tried tabular format and other things, but to no avail. I also tried a calculated field where I defined a formula as =If(ACT Type = "LABOR",Qty,0) and this didn't work either. I got calculated columns under Labor, ODC and Excess, instead of only under Labor.
