Thanks for the quick reply ZZ.
The data on Tableau is already being sourced from 2-3 files, hence it would not be efficient process. Any other suggestions using a calculated field?
Use the below formula for next month sales derived
if lookup(attr(INT(REPLACE([Month],'/',''))),1) - lookup(attr(INT(REPLACE([Month],'/',''))),0)
> 1 then null else LOOKUP(sum([Sales]),1) end
Also in edit table calculation check only month column:
Attached is the workbook.
nextmonth_v10.5.twbx 20.7 KB
thank you so much Ankit. It works well with my file.