Hi,
thanks for sharing.
I tried, but maybe I did not understand it correctly,I didn;t get the result I needed.
refer attached pic for what I am trying to achieve.
those columns in light blue is my pivot table, where column totalSMALL is the total quantity in smallest unit of the item, column ratio is the ratio of small package to big package of that item.
the 2 green column is what I am trying to add to my pivot table result, showing the total small package qty of the item being converted to big packaging (QUOTIENT function) and small packaging (MOD function)
thank again for all advice.