$(1)$ Split the $$year$-$month$$ column into two columns $$year$$ and $$mon$$ containing the foul year number and the first $3$ characters of the month, respectively.

$(2)$ Split the $\backslash$Region$\backslash$Group$\backslash$Product$$ column into three columns $$ Region, Group and Product.

$(3)$ Apply the calculation necessary to produce another column containing the unit price.

NOTE: Subsequent analysis is for ICE CREAM ONLY.

$(4)$ Create ONE pivot table to answer the questions: $$For a particular year, what was the percentage $\%$ revenue breakdown by region? For a particular region, what was the percentage $\%$ revenue breakdown by year?$$ Percentages should be of the TOTAL revenue $($not row or column revenue$).$

$(5)$ Now, create a $3-$D clustered column chart in the following format $($see below$).$ Include a title, labels for x and y axis, and data labels $($percentages$).$ NOTE: Your percentages $\%$ will be different.