This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Could you please help to solve the condition with following dataset:
Venture Purpose Value
1 Forecast 100
2 Planned 200
3 Actual 0
The purpose is to set the condition only for Venture "1" , the rest (2 & 3) will use all the time "Planned" variable from the Purpose column and corresponding value.
For the Venture "1" I need to use "Forecast" if the value exist, otherwise use "Planned" if there is a value or use Actual (as a last resort) if both Forecast and Planned will be equal to zero (null or empty cell).
I applied your workflow, but got issues with missing the data in Cross Tab output. This data after applying Cross tab the data in the input partially miss its content, since method for aggregating has been selected "First", but I need all values kept as it is.
This is Cross tab input data:
Cross tab Output:
Could you please advise, whether there are another aggregation methods that does keep all values in place?