Forum Discussion
Responsive ResidentHow to show records without historical data?
Check out your example file here:
https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2Wg
I'd also suggest you make consideration about where certain attributes belong. Is the product group an attribute of the sale or is it an attritube of the product? Is the customer type and attribute of the sale of is it an attribute of the customer?
In the provided example i moved the customer type into the customer table. Consider removing the separate customer type table and the customer type id from the sales table.
Solution SageWell, you mentionaed that jane doesn't have any vegetables sales, so there's not supposed to be any sales amount displayed, no?
Responsive ResidentNot a sales amount indeed, but customers similar to Jane (like Joe who is in the same customer type) bought vegetables so I would like to see a value for 'sales similar customers'. And the 'sales similar customers' is also not dispalyed. And this is while the sales Joe did, are taken into account for the sales similar customers total so somehow it is taken into account. Seems like it just not displayed.