Sum Multiple rows

[Sara94]

Hi guys,

Could you please suggest me the best way to find the total sales for monthly data for couple of customers? I've provided a sample of the data that I'm working on below

[Emil_Kos]

Hi @Sara94,

please try experimanting with transpose or cross Tab tool. After you will transform the data you will need to use sumarize tool.

[MinaGO3]

Hi @Sara94, 
You will likely want to transpose your months to aggregate them (but it is possible to aggregate them without transposing, just not the typical data format). 

Please see attached workflow. Hopefully, this helps.

[ArtApa · Accepted solution]

Hi @Sara94 - Here is one more idea for both rows and columns.

[Sara94]

@ArtApa @MinaGO3 @Emil_Kos thank you all!! you made it pretty much clear 🙂

[ajax459]

First filter the customers and then use cross tab tool over the months columns grouping by the customers