I am working on the straight table where in I am showing Country and sales. Requirement is to show 20 countries every time.
e.g. Even if I receive sales data for 5 countries, I need to show '0' sales for rest 15 countries.
For that I am loading Country’s reference data table having 20 countries along with actual data sheet. So that in table there always will be 20 countries.
Now the issue is - when I am opening my dashboard it is showing only those countries present in actual data. Post reload it is showing all the 20 Countries. Not getting why reference data is not getting loaded at first instance only.