How do I add a Lot total or Line Items Totals to my Advanced Lot?
What's the issue you're facing?
Solution
Lot total = The most important price value within the entire lot. This can be a cell that sits in a total column/row that has a formula in or any other cell with a price. Lot totals are ultimately the value in which cell participants responses are ranked by. For example, this could be a cell within a total column and total row that adds up cells within the advanced lot table to give a summed total, Or it could be a specific cell with a price that is deemed the most important factor within the whole lot.
Line item
total = The cell in which is most important within a particular line. This can
be a cell that sits in a total column/row that has a formula in or any other
cell within a specific line that has a price. For example this could be a total
cell that adds up cells within a line to give a summed total, Or it could be a
specific cell with a price that is deemed most important for that line item.
To add a Lot total you first need to identify which cells value within the whole lot is the most important. This will be the cell the participant responses are likely ranked by. When identified click into the cells ‘Edit info’ button and here you can click the ‘Is Lot Total’ tick box. A green star will now appear in the cell that has been given the lot total status. See image 1 below.
To add a line item total identify the column where you want the line item total to sit, click on the column header and tick the ‘Make this line item total’ tick box.
Image 1: Greenstar denoting the lot total cell.
Related Articles
How do I manually add line-item rows and cell data to my Advanced Lot?
What's the issue you're facing? How do I add rows and column to my Advanced Lot manually? Solution Each advanced lot is made up of columns (lot components) and rows (line items). For each column you will determine what type of cell data will be ...How do I add Total columns and rows to my Advanced Lot & how can I use formulae to do calculations in my lot? (Optional)
What is the issue you're facing? I would like to know how I can add total columns and rows to my Advanced Lot and how I can use formulae to do calculations within my lot Solution When building an advanced lot table, there is the ability to include ...What is the Event Total in an Advanced Lot and how do I use it?
What's the issue you're facing? I have created my lots and I see I have the option to create an Event Total. What is this and how do I use this in my event? Solution Event totals allow you to create formulae that combine any price or numeric cell ...What do I do if I cannot add enough rows or columns to my Advanced Lot?
What is the issue you're facing? Whilst creating my Advanced Lot I am not able to add enough rows or columns. How do I overcome this? Solution Within advanced lot event there is a maximum cell limit of 5000 cells. There is also a limit for the number ...What are Advanced Lots?
What is an advanced lot? In the MarketDojo Sourcing tool there are two options to building RFQ and eAuction lots. Either a simple lot or an advanced lot. A simple lot is as the name would suggest 'simple'. It allows you build a lot where you only ...