Total 12 columns of data

[grapevine]

I am accessing data from an OLAP cube which has multiple years data. I want to see just the totals for items rather than the raw data.
I need to be able to see one column with totals for 2016 and another for 2015 for two different values
eg

Product Name Sales for 2015 volume total for 2015 Sales for 2016 volume for 2016
Product one
Product two
etc
etc

I was thinking about whether I could use a set for this, but it does not seem to add the field together. do you have any suggestions about how best to achieve this?

currently it shows
Product Name jan feb mar etc
Product one
Product two

Many thanks

 

[FranzV]

What version of Excel are you using?
Are Power Query and/or Power Pivot available?
Could you post a screenshot of a sample of the raw data?

 

[grapevine]

Thank you for replying. I have since managed to locate a solution. I managed to get the two sets to group initially, then managed to find a value in the Measures section that performed a relevant moving annual total that I could use instead
Thank you for looking