Custom Calculations
Custom calculations are a dynamic feature in accoPLANNING that enhance your data visualization. They allow you to add non-editable dimensions to your grid and populate them with calculated data. Think of custom calculations as a visual extension to your existing Power BI data model, seamlessly integrating beside it. Unlike shadow calculations, they don't rely on predefined measures for data population.
Consider this scenario: You have a data dimension with 'Months' in columns, 'Products' in rows, and 'Sales Quantities' as your measure. To gain insights into your quarterly performance, you could create a custom dimension for each quarter. Then, configure its calculation to sum up the sales of the respective months within that quarter.