I am re-modifying report 10157 (Sales History); I changed the dimension into 12 months from original 8 months. I also added column # 13 for displaying the TOTAL of the 12 months columns. At the footer I added GRANDTOTAL for each column.
Per requested; I need to sort this report descending based on the QTY. SOLD so we can see which items were sold the most and descend to the lowest.
It’s things like this, that are so easy in Crystal or other Reporting programs, that make life difficult when creating custom reports in Navision & sorting without a key.
I am re-modifying report 10157 (Sales History); I changed the dimension into 12 months from original 8 months. I do not know how to modify dimensions. Could you help me?