Cost values not summing on table

[z-rising]

I'm hoping this is something simple I just don't know how to do.

I am pulling 7 columns from a table in Desktop into a table visual.  The first 3 columns are text based - location, item, description.  Then next four are all cost columns with numerical values based on scenario.

The table is showing every row because they have different costs even though the first three are the same, so in the table has hundreds of rows with the same location/item/description, and I'd like to show one summed amount for each location/item/description combination.

[Anonymous]

Hi @z-rising ,

This sounds simple enough to be achieved by putting all the fields in a table and adding aggregation with the help of a slicer.

Please feel free to correct me and provide more information if I have misunderstood you!

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[sumanth_v]

summarize the fileds based on aggregate calculations. Can you show the data if it doesnt have any private information.