how to display changing column headers in labels in straight table

[vireshkolagimat]

Hi Guys,

I have sample data in the below format.

Prod   27-May   3-Jun

A        8             7

B        4             9

I am using straight table to display the data and using Prod as dimension and 27-May and 3-Jun as as expressions.

When i load this data 27-May and 3-Jun will load as numbers and currently in label i'm manually writing the label as 27-May and 3-Jun.

How to make it dynamic. I mean whenever the 27-May and 3-Jun changes, i want the labels should be updated automatically.

I tried to use FieldName but didn't get the expected output.

Appreciate your help.

Regards,

Viresh

[sunny_talwar]

Assuming date is the field name, may be this:

=Date(Max(Date), 'D-MMM') for 3-Jun

=Date(Max(Date, 2), 'D-MMM') for 27-May

[vireshkolagimat]

Field name is 9-Mar and it is reading as number 42438. So the fieldname will chage again.

[sunny_talwar]

Are you using CrossTable Load? Would you be able to share a sample?

[vireshkolagimat]

No i am not doing cross table load. It's same table what i shared as sample.

[settu_periasamy]

Maybe look this..  read header date field as is in source

[Qrishna]

This way?

[vireshkolagimat]

Yes but square brackets are not required.