Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have items in categories that are either "included" or "excluded". I need to create a straight table that lists the excluded items, but the calculation involves summing only the included items for that category. (it involves some weighting of the actual price based on included items).So my problem is how to create a set analysis expression that sums included items while displaying only the excluded items.
I am really just looking for the correct set analysis concept that will accomplish this idea.
Thoughts?
The solution I found was to join the data for the included items back into the model by the aggregation point which was Category in this example. I do not think it is possible to do this solely with set analysis. QVW is attached for reference.
Not really clear on what you are trying to do. Please provide a sample QVW and describe what values you expect to se in your application object.
Here is a very simple example in Excel to demonstrate the concept. Note I have a data sheet and then a result sheet.
The solution I found was to join the data for the included items back into the model by the aggregation point which was Category in this example. I do not think it is possible to do this solely with set analysis. QVW is attached for reference.