Create a "not linear" Date dimension

[fabio]

Hi,

i would like create a chart (table) like that:

[Date], [weigth]

backward  100Kg

may 120Kg

jun 14Kg

jul 25Kg

Aug 123Kg

further 12Kg

It's just a simple example for help me tu explain you.

A need to show the values in a range splitted by a dimension (month, day..) and "sum" all the value existing outside this range in a "virtual" value of the dimenson (backward e further..)

Any idea?

thanks

[Gysbert_Wassenaar]

Create a new field with your custom date value 'further':

CustomMothnDimension:
LOAD * INLINE [
CustomMonth, YourExistingMonthFieldHere
may, may
jun, jun
jul, jul
aug, aug
further, sep
further, oct
further.... etc
];

Then use the new CustomMonth field as dimension in your chart.

[fabio]

Thanks, but it needs to work dinamically, based on the current month selection 😞