I dont know about your "indexing" question, but i will suggest an alternative way of solving your initial problem:
I have an input table with these columns:
Product_id, Year, Quarter, Turnover
and this table can be denormalized into this table
Product_id, Year, Turnover_Q1...