Thanks Deepak. Will take care of this.
You can try wrapping your calculation in ZN function.
1 of 1 people found this helpful
This can be a complicated problem. The suggestion to use ZN() that @Meenu suggested only works if a) the data has the dimension values (i.e. the dates) with Null measures or b) the data is sufficiently padded out inside Tableau. However the way Tableau does padding can make it challenging to get the desired results depending on how sparse your actual data is, at present the best would be for you to post a packaged workbook with some sample data so we could take a look.