50Anyone please guide me to generate a report for Revenue over COGS for individual species?
Currently, each item code is tagged to a SPECIES Dimension since end Feb.
We would like to see a breakdown of gross margins of a particular SPECIES dimension across a certain period.
Below is one of the samples I did in order to try achieve the report based on our required scenario.
However, this report shows every GL Account instead of only those that we need for Gross Margins, instead of exporting the following and filter out those GL Accounts we need, anyway for us to setup one and get the report generated on a recurring basis?
