Add attributes to the price list
Add attributes to the price list
By using the matrix model it’s possible to add columns to your liking. This allows you to go read additional attributes related to the TOP part, making these informations available to the excel sheet.
EXAMPLE:
Let assume that the user added the attributes “Country” and “Client” to the TOP part and wants these two values to be read and shown in the price list sheet along with the other attributes.
To make these attributes appear in the price list sheet it’s necessary to open the “BACKSTAGE” sheet and compile the first cell of every new column with the same attribute name you want to go read.
IMPORTANT: the attributes name must be written uppercase!!
After that you need you need to write an “x” in the third row of every column you added (this is the row related to the TOP part of the tree).
This should be the result after the estimate function.