I am working on creating an income statement that is grouped (sub totaled) by our Finance Dimension 5. In this example - how do I add a row for the subtotal of each of these vegetable types?
Hi Kasey,
Can you share what other dimensions you have? Is crop type one? Does you account dimension have a hierarchy?
Yes, we also have Crop Type, Resources, Operations, and Crop Years, etc.... The Account Dimension does have a hierarchy, for example 1) Revenue 2) Prod Revenue 3) Crop Revenue 4) Account (base element shown above).
I want to group these accounts by the common Crop (as shown above) and show a subtotal for each group.
