Hi,
I came accross an assessment to derive volume, %volume and YTD for the transaction sales attached herewith spreadsheet where there are 6 sheets, the instruction sheet has description of raw data, question sheet contains the actual assessment questions and the next following sheets are the raw data like transaction, production info, supplier info and FX data.
Can you help me derive the results?
I am curious to understand the metrics of sales in detail.
Thanks in advance