I have a dataset for products and their corresponding sales at a year level. Some products are present in both the years (previous and current). Some are there only in current year and vice versa.
When i display these products and their sales, for the products which are not there in current year, sales column has missing values. When i sort the data by descending order of sales, the products with no sales in current year ( missing value rows) come at the last. Hence my bottom products come as these. But i want the products with actual low sales to be shown as the last products. Is there a way by which i can replace these missing values with 0s?
I am attaching a sample dashboard for reference.
Referring to the dashboard - Dairy Milk should come in the end.
You can add zeroes to the data using a calculated field similar to the following:
However, the sort won't work based on this calculation because it is a table calculation. You could manually sort the Product members by dragging Dairy Milk to the bottom of the list.