In a straight table how can I get it show all records within a dimension even if there are no records under a certain selection. For example my dimension is Products and in a certain week one of the products was not sold but I still want it to show in the table.
Try adding an additional expression to the straight table with set analysis to evaluate all sales (e.g. sum( {1} Sales)) then hiding the column (option in presentation tab).
Try adding an additional expression to the straight table with set analysis to evaluate all sales (e.g. sum( {1} Sales)) then hiding the column (option in presentation tab).
