1 of 1 people found this helpful
Do you need it to actually show a 0 or would an empty row work?
Try going to Analysis, Table Layout, Show empty rows.
* Edit * Nevermind! I had one hidden column for currency and basically it gave me an empty row for all currencies. It works perfect thanks!
Hi Hope, Thanks a lot for your answer. I actually didn't think of it! empty rows would be ok. However it is now showing a lot of empty lines that are redundant. For instance I get multiple lines with Coca Cola Light and no value for the average price, and one with Coca Cola Light and average price...