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.
Responsive ResidentI found the difference. It is due to the orginal report having 2 column from product group in the table. I didn't realise that was important until now.
However, when I add the second column, the total remains correct and the vegetable line is even displayed but without a sales amount in it. I tried to combine ID and description into a concatenated field but that is not enough (as shown in the second table). Do you have any idea how I can make that sales amount displayed correctly?
Solution SageWell, you mentionaed that jane doesn't have any vegetables sales, so there's not supposed to be any sales amount displayed, no?
- Smalfly
Not 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.
- NickolajJessen
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.- Smalfly
NickolajJessen That works. Thank you so much for your help!
You are 110% right on the number of attributes in the fact table by the way. I am aware of that but I do appreciate that you try to warn me for it.