Sum multiple rows

[jak82]

We are using PowerPivot to show the companies on the rows with a 2015 and 2016 split each within different rows for the company. We are need to a total row along the bottom one for 2015 and one for 2016. In the columns we have week 1 2 etc, we need to total all the 2015 for week1 etc.

Any ideas how to do this in PP?

Thanks

 

[Matt Allington]

Please post a sample of what you have in a pivot, and what you want.

 

[jak82]

Please post a sample of what you have in a pivot, and what you want.

Thanks Matt, we managed to solve it