Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.
Thanks
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).
Thank you Rachael