How can I solve this demand, need to know sales at hoppy hour for articles where have lower price at happy our and articles that no not have a lower price at happy hour. (all articles have two tariff but some have different price and others not.
Article | Tariff | Price | Quantity | Revenue | Revenue 11 lower | Revenue 11 no change |
a | 1 | 20 | 3 | 60 | | |
a | 1 | 20 | 4 | 80 | | |
a | 11 | 20 | 6 | 120 | | 120 |
b | 1 | 36 | 1 | 36 | | |
b | 11 | 18 | 3 | 54 | 54 | |
c | 11 | 25 | 5 | 125 | 125 | |
c | 1 | 50 | 6 | 300 | | |
c | 11 | 25 | 1 | 25 | 25 | |
| | | | | 204 | 120 |
Articles can be sold at different Prices depending on Tariff applied (Happy hour)
Some Articles have same price independedly of Tariff applied (Happy hour)
I am aiming for
1. Revenues for Articles sold at Tariff 11 (where Price 11 = Price 1)
2. Revenues for Articles sold at Tariff 11 (where Price 11 not equal Price 1) but only the ones sold at Price 11 lower than Price 1
Thanks