Why use Pivot table Calculate field for Sell thru | How to Calculate Sell thru in Pivot table
Note:- Pivot table working on Sum of total .
when using base file sell thru column in pivot . pivot sum of sell thru . pivot not divided (Net sale/ Net Rec)
So , using calculate field in pivot and using function = Net sale/Net recived
Below Example:
Below pivot summary in pivot Raw File ST Sum and Calculate field ST divided
Calculated field right output
