Webi logic Measure and Dimension in one function

[former_member443133]

Can anybody solve the logic in attachment. I have tried using Sum ,if, where and in function but getting error message.

[daniele_tiles2]

Hi Ehethesham,

you should work with the ForEach operator. However, can you upload a more detailed picture or write the table in the post? Because I really didn't understand which are the rows you want to add (I tried in Excel and got 5 as sum for the rows with Type Industry).

Best regards

Daniele Tiles