Forum Discussion
Sum based on a condition
Hi fumbling and hoping for some help. The examples I have looked at have not helped. ... In the table below I am trying to sum for the city, based on the component. So NYC total would be 10 and the Tulsa total would be 6. The overall cost of Service # A equals 16. I will be using a slicer to select the city. Service # equals a single product. Components are all part of that single product.
Any help would be very much appreciated. Thanks, John
| SERVICE # | COST | COMPONENT | CITY |
| A | 5 | Z PART | NYC |
| A | 1 | A PART | TULSA |
| A | 5 | Z ADD ON | NYC |
| A | 5 | A ADD ON | TULSA |
OHHHHHHH Thank you!!!!!
4 Replies
johndolan2
Can you also share the expected result as you have shared the data?Absolutley - The result for NYC would be 10. And the result for Tulsa would be 6. I only need to be able to show these on a card. So on my report page if I selected NYC on my city slicer, my card visual for NYC would show the number 10. John
