Values on Dimensions

[#1]

Hi,

I am creating an Aged Debtors and Creditors tab showing two tables of outstanding AR and AP amounts that fall within various periods (0-30, 30-60, 60-90 etc...)

The ranges of the periods are loaded within a seperate table with three columns [Aged Period], [Aged From] & [Aged To], in which [Aged From] & [Aged To] are inputfields that can be amended by the user.

I have set up [Aged Period] as the dimension for the two Aging tables, but would like to show the corresponding values of "0-30 days", "30-60 days", "60-90 days" etc. instead of "Period 1", "Period 2", "Period 3" as the dimension labels for these Aging tables.

Can anyone advise how I could do this.

Thanks,

Jonathan

[amars]

Hi Jonathan,

Crate a INLINE Table

Load * INLINE

[ NewLabel, OldLabel

0-30 days, Period 1

30-60 days, Period 2

60-90 days, Period 3

........];

like this & then use the NewLabel instead of the OldLabel. Make sure all values are listed in the table

Regard's

Amar