locked
Custom Date Format RRS feed

  • Question

  • Hi,

    I'm trying to figure out how to apply custom date format and use them in pivot tables.

    I'm using a date field which hold the month in "mm/dd/yyyy" format. If I drag this field in a pivot table, the rows are ordered correctly but I'm not able to shorten the label using the cell or chart fomat option.

    If I use the format function in a calculated colum, the resulting field is not sorted by date in the pivot table or chart.

    I found a work around : I'm using the format function within calculated field that I use as a measure order key. It simulates the expected behaviour but it's not a viable long term solution.

    Is there any other options to solve this ?

    Regards,

    Dejan

     

    Tuesday, October 26, 2010 3:58 PM

Answers

  • Hi Dejan,

     

    When you drag a field to a row labels it is treated as a string and there is no way to format it afterwards.

    You should stick to the workaround you found for now, while we should provide better solution (extended formatting options) in next version.

     

    HTH,

    Vaghinak

     

    • Marked as answer by Dejan MILIC Friday, October 29, 2010 9:36 PM
    Friday, October 29, 2010 6:04 PM