Hi,
I have some P&L and Balance Sheet straight/pivot tables that show both absolute and relative differences between columns. These differences are calculated using Column(ColumnNo) type syntax, as opposed to either the columns' expressions (which would be too messy to maintain) or labels (which are dynamically calculated with dates or determinantion of whether Full Months or MTD etc.).
I am now testing for whether Budget data has been loaded (as this is a template I'm deploying across multiple companies with the same ERP data source). If budget data doesn't exist the Budget and comparisons to Actual columns are to be hidden on the Presentation tab (with the calculation of the columns seemngly also needing to be made conditional on the Expressions tab).
This attempt at standardisation and flexibility is causing me problems however when calculating comparison between columns appearing after these hidden and not calculated budget columns. Can anyone advise is there is another way of setting up a name of a column. Do columns have codes that can be set and not changed, which are neither the labels shown to users or the column positions ?
Thanks,
Jonathan
