Table in Query editor

[jagtaps]

Hello,

I have a table containing the Cost Types which are repeating for 12 rows (representing 12 months data), i have per month cost update in uploaded data.

Can you add column in table and cumulate the costs based on cost types??

Regards,

[v-jingzhang · Accepted solution]

Hi @jagtaps 

Your expected output is not clear to me. If your data is similar to below and you want to get the total cost per cost type, you can group by Type column and calculate the sum of Cost column. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[PhilipTreacy]

Hi @jagtaps 

Sounds like you want to Group the Cost Types and sum the costs in the months column.

Please supply some sample data as a text file/table (copy and paste here) or supply your file.

Regards

Phil