XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XLCubed Business Rules"
(Created page with "XLCubed Dynamic Charts formatting can be modified from the XLCubedFormats and XLCubedBusinessRules sheets. The XLCubedBusinessRules sheet is included in the workbook automati...") |
|||
Line 33: | Line 33: | ||
It is possible to configure the XLCubedFormats sheet to apply custom formatting to the dynamic charts based on the mappings defined in the XLCubedBusinessRules sheet. | It is possible to configure the XLCubedFormats sheet to apply custom formatting to the dynamic charts based on the mappings defined in the XLCubedBusinessRules sheet. | ||
− | [[File:Column Charts.png|center|Column Charts]] | + | [[File:Column Charts.png|600px|center|Column Charts]] |
Revision as of 16:18, 7 July 2021
XLCubed Dynamic Charts formatting can be modified from the XLCubedFormats and XLCubedBusinessRules sheets.
The XLCubedBusinessRules sheet is included in the workbook automatically when (xxxxxxxxxxxxxxxxxxxx) The XLCubedBusinessRules sheet serves to map the predefined business rule types on to the hierarchy members where they are applied to.
These types are:-
Revenue or Growth Good
Expense or Growth Bad
Total
Subtotal
Actual
Forecast
Plan
Current Month
Current Year
ExpectedExpenseSign
ExpectedRevenueSign
ExpectedGoodGrowthSign
ExpectedBadGrowthSign
It is possible to configure the XLCubedFormats sheet to apply custom formatting to the dynamic charts based on the mappings defined in the XLCubedBusinessRules sheet.