column name as a month & Year

[Anonymous]

hello

i want month as well as year in column name. i tried many exp in label but its not working .

Thank You..

[Anil_Babu_Samineni]

Not sure, What does this showcase of Label? Is there any logic?

[Chanty4u]

can yougive some sample data ?

whcih object you are trying?

[Anonymous]

post the sample data with expected result sample

[Anonymous]

straight table

[Anonymous]

i did it in paint.

[Anil_Babu_Samineni · Accepted solution]

I know, that is from paint.

Usually, In label we call call it as =MonthName(Max(FieldName))

[Chanty4u]

you can give each expression with  your format label?

[Anonymous]

Try this ....Month(Date)&'-'&Year(Date)

Assuming :

Take a pivot table with add ur dimensions which includes your date dimension(use the above logic) and add ur expressions. Now drag this date dimension to the top to see them as columns... jan-2016 feb-2016 and so on..

[Colin-Albert]

Use the monthname() function on your date as a dimension.

Either use a calculated dimension monthname(YourDateField) or create a monthname field in your load script.