Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Field name is 9-Mar and it is reading as number 42438. So the fieldname will chage again.
Are you using CrossTable Load? Would you be able to share a sample?
No i am not doing cross table load. It's same table what i shared as sample.
Maybe look this.. read header date field as is in source
This way?
Yes but square brackets are not required.