Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
i would like to create a table with three columns like this:
ORDER, TITLE, VALUE,
1, TITLE A, 44,
2, TITLE B, 55,
......;
--> The problem is that i would like to always see all the titles... but they are filtered by the presence of a 'value'. Soo if there isn't one the title won't be shown.
I tryied with
if(sum(value)<>0, sum(value),0)
but this doesn't work.
Thanks.
Please share the data set sample and expected output