How to compare multiple results coming from the same file
Hi All,
probably there is not an easy solution to my question but I would like to know which is the right way to work on.
In a QV file I am comparing the competitiveness of different products. This analysis is achieved through several sheets where specific items (such as turnover effect, turnover trend, profitability,...) are analysed.
Each item results in a score and all scores are summed to have a rating which represents the rate of competitiveness. So far everything goes well.
The above process should be done for each product.
Problem is I am not able to "freeze" the result for the analysed product and when I restart the analysis for another product then the final result is overwritten with this last one and no comparison is possible
I would like to add a further sheet where QV "stores" each analysed product with its rate to have a final Matrix of comparison among all products.
To work well at this stage I do not need any "choreographic" thing. Just the list of analysed product with relevant results.
Example:
Product A --> I run the process and analysis assigns a rating = 3. This is stored in the last sheet.
Product B --> I restart from the beginning the process and analysis assigns a rating = 7. Also this is stored in the last sheet.
Product C....
Product D....
When all products have been analysed the last sheet shows me this:
Product A = 3
Product B = 7
Product C = 2
Product D = 9
I can understand that Product D is the most competitive.
