Level | Name | Industry ID | Company Sector ID | Sector | Applicability ID | Link | Link Name | Solution Name | Prod 1 | Prod 1 Rev | Prod 2 | Prod 2 Rev | Prod 3 | Prod 3 Rev | Prod 4 | Prod 4 Rev | Prod 5 | Prod 5 Rev | Total Revenue by Row | Revenue Split |
1 | Dairy Farms | 43523 | D43523 | Dairy | D43523Dairy | (blank) | 01-Dairy | 43523:airy | C123 | $100 | G231 | $50 | G231 | $50 | D637 | $74 | U369 | $32 | $306 | |
1 | Dairy Farms | 52236 | D52236 | Dairy | D52236Dairy | (blank) | 01-Dairy | 52236:airy | D637 | $74 | C123 | $100 | N628 | $73 | N628 | $73 | C123 | $100 | $420 | |
1 | Dairy Farms | 74245 | D74245 | Dairy | D74245Dairy | (blank) | 01-Dairy | 74245:airy | U369 | $32 | D637 | $74 | C123 | $100 | C123 | $100 | G231 | $50 | $356 | |
1 | Burger Deluxe | 27434 | B27434 | Burger | B27434Burger | (blank) | 01-Burger | 27434:urger | C123 | $100 | U369 | $32 | G231 | $50 | G325 | $26 | D637 | $74 | $282 |
<tbody>
</tbody>
The end row "Revenue Split" is the row I need completed". For example there are 6 occurrences for C123 but the total revenue for C123 is only $100 dollars, meaning the revenue from C123 should be split 6 times. I don't want the revenue being counted more than once, I want to be able to split it based on number in occurrences in the table. Is there a way to do that? FYI Total Revenue by Row is wrong because it is counting the products more than once.
Last edited: