updated pivot table design