Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have one dimension and secondary dimension and one measure for a pivot table.
sum({<year={'2023'},sales={'total sales'}>}spend)/vDenominator
I'm using this measure for a pivot table.after exporting the data into excel getting null values.
i don't want to see the nulls even after exporting the data into excel.
In the dimensions we have the option check box to exclude or include but in the measure how?
HINT: if i place the <>0 in the expression we can achieve this , but i don't know how to place in the expression.
Thanks Brun.
I got the solution for this issue.
Answer: under the dimension properties we have the limitation there selected the exact value as >0.Then I exported the data into excel. There I'm not getting null vvalues.my issue resolved.
But thanks for reply brun.
Hi, you uncheck the Show Null check-box to remove Null from the dimension.
Thanks Brun.
I got the solution for this issue.
Answer: under the dimension properties we have the limitation there selected the exact value as >0.Then I exported the data into excel. There I'm not getting null vvalues.my issue resolved.
But thanks for reply brun.