Hello, hope someone can help me on that.
I have a table that shows the service contracts that subscribers pay me monthly (the price of a service can change for different customers):
| Subscriber | Service | Price |
| Ana | Positioning | 50 |
| Ana | Positioning Plus | 60 |
| Ana | Standard | 30 |
| Ana | Standard Bonus | 40 |
| Ana | Custom | 20 |
| Peter | Standard | 24 |
| Peter | Standard Bonus | 32 |
| Peter | Positioning | 50 |
I would like to conditionally summarize: if the subscriber has positioning plus, then I would like to show only this information but with the price added (positioning + positioning plus = 110). The same for standard with standard bonus, show only "standard" with the price 30 + 40 = 70. The result would be:
| Subscriber | Service | Price |
| Ana | Positioning Plus | 110 |
| Ana | Standard | 70 |
| Ana | Custom | 20 |
| Peter | Standard | 56 |
| Peter | Positioning | 50 |
Thanks in advance!
