Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
sum({1<Version={'1.1'},Product={'alpha'}>} orders)
This when added in a graph or straight table, gives correct value only
when version 1.1 and product alpha is selected in multibox.
However I want this value to remaining unchanged irrespective of the values selected in the multibox for version and product.
What is wrong with my current set analysis?
I also need to add Max and aggr function to it
max(aggr(sum({1<Version={'1.1'},Project={'alpha'}>} orders),dim1s,dim1a))
dim1s and dim1a are not in multibox so we dont have the problem of selection for them.
This set analysis condition should produce correct results if everything is spelled correctly. Try the same without single quotes for the Version field (in case the version is a numeric field). Other than that, i t should work. You can try and post a simplified example here, and someone could try to troubleshoot it...