SUM & LOOKUP
Just wanted to clear some doubts on usage of SUM & LOOKUP at the same time for same line item
If I use SUM & LOOKUP both at the same time for the same line item, its giving me correct details as expected
However, if, don't want to use SUM & LOOKUP at the same time, then what can be the options -
- I tried with subsidiary views & it worked as well
- If I want to break this equation into SUM & LOOKUP separately, its not working. I tried creating an intermediary module with same dimension, however its still showing as error
Any idea where have I gone wrong
In another module, dimensionalized by Region, do your cost sum. Then, if you need the totals for that region, you can do lookups using a list formatted line item (Region).