Hi group. Newbie poster here using Excel 2013
I hope you can point me in the right direction.
I have a list of base data of that contains a number of columns:
Salesperson / Customer / Area / Invoice Num / Date / Item / Qty /Unit sales Price / Line Sales Value / Unit cost / Line cost.
I can create a pivot table and only want to show the Sum of Qty / sum of Line sales Value & GM% in a pivot table - which I can easily do setting a calculated field "(Line Sales Value - Line Cost)/Line Sales Value".
I want to issue this to the business and allow any user to still have pivot table functionality to group or show by item or customer or both, but "lock and hide" the unit cost and Line cost, or simply make them non selectable from within the pivot table. (I appreciate that if you have the Qty Value and GM you could work back to the cost -I've made the point already
)
I hope you can point me in the right direction.
I have a list of base data of that contains a number of columns:
Salesperson / Customer / Area / Invoice Num / Date / Item / Qty /Unit sales Price / Line Sales Value / Unit cost / Line cost.
I can create a pivot table and only want to show the Sum of Qty / sum of Line sales Value & GM% in a pivot table - which I can easily do setting a calculated field "(Line Sales Value - Line Cost)/Line Sales Value".
I want to issue this to the business and allow any user to still have pivot table functionality to group or show by item or customer or both, but "lock and hide" the unit cost and Line cost, or simply make them non selectable from within the pivot table. (I appreciate that if you have the Qty Value and GM you could work back to the cost -I've made the point already
)
