Is there any other way to substitute BEFORE?

[#1]

With this code, i'm able to get the layout that i want but is there any ways to apply so that my data won't show NULL Value?

Below is the code i used.

if

( Before( Sum (IF(Status <> 'ASD', TEU,0)) , 12) = 0
OR IsNull( Before( Sum (IF(Status <> 'ASD', TEU,0)) , 12)) = -1, null

(),

I tried suppress null value but it doesnt help. Is there any code for me to substitute BEFORE because it shows all the data even if the data is null.

[#2]

Yeap, i did but it still show null value. I think its because i used before(). Please help me!!

[gaurav2017]

Dear,

This Before() function returns NULL in all chart types except pivot tables.

Hope this helps

Regards,

[#4]

I'm using pivot tables but unfortunately, it returns NULL. Is there any function besides Before() function to be used?

[#5]

Thanks for your reply! I solved it already. i added in TEU>=0