Generate data for previous month if current month data not available
Hi Team,
I have a dataset in which i have a feild called ID whose value is coming from the database
Suppose i have refreshed the data for the month of jan
Now, if the i have the data for the month of Jan in backend, so the value of ID will be 0 and it will show that data is updated.
However, if there is no data in the database for the month of Jan, it should show the data for the month of Dec and the value of ID will be 1 stating that the data is not updated.
How should i show the data for the month of december when we don't have january data in the database using loops.
