Add a column to a table with a conditional sum

[etiennesan]

Hello everyone,

I have a problem that I have been trying to solve by looking at many solutions but couldn't find one that would work for me.

Here is the data: I have for many product ID, the inventory for each warehouse. Meaning I have a column for ID, one for warehouse, and one for the inventory.

I want to have a table showing the ID, as well as other information from other tables (for example description), and then split the inventory on different columns for each warehouse. Basically trying to do a pivot table, but I need to keep the versatility of a regular table.

I tried adding a column with the below formula but I'm getting an error.

=Sum(If(warehouse='/name of wh/', inventory))

Anyone has an idea on how to solve this issue?

Thank you very much!

Etienne

[Vegar]

You could try using set analysis instead of sum(if()). 

=Sum({<warehouse={'name of warehouse'}>} inventory)

[etiennesan]

Hello, thank you for your reply.

I also tried this solution, but I get the same error: invalid dimension.

[etiennesan · Accepted solution]

Actually I have found the solution: the data should be added as a measure and not a dimension. Now I don't have any error.