Hi guys! I need some help.
Please refer to the table below as you answer my questions.
| Product | Store | Price | |
| A | 1 | 5.00 | SUP-1 |
| A | 1 | 5.00 | SUP-2 |
| A | 2 | 7.00 | SUP-1 |
| A | 2 | 7.00 | SUP-2 |
| B | 1 | 10.00 | SUP-1 |
| B | 1 | 10.00 | SUP-2 |
| B | 2 | 9.50 | SUP-1 |
| B | 2 | 9.50 | SUP-2 |
| C | 1 | 21.00 | SUP-1 |
| C | 1 | 21.00 | SUP-2 |
| C | 2 | 19.50 | SUP-1 |
| C | 2 | 19.50 | SUP-2 |
I have a separate Object that shows the Total Price.
Using Set Analysis, how can I output the:
1. Total for a "selected" Product
For instance, Product A's Total Price is computed as 5.00 (Store 1 price) + 7.00 (Store 2 price) = 12.00
I only need one price of the product for each store.
2. Total Price of ALL products (if no specific product is selected)
Bearing in mind the above computation for a certain product, I need to get the Total Price for ALL products.
Product A (12.00) + Product B (19.50) + Product C (40.50) = 72.00
Thank you in advance!
.png "Former Employee"){kind=icon}
