14 Replies Latest reply: Apr 16, 2012 9:15 AM by Peyman Azimabadi RSS

    Displaying date in "class" function label

    Peyman Azimabadi

      Hi all

      i have a pivot table and in it's Dimensions i have used a class function for classification as follow:

       

      class ( myDate , varPeriod , 'Date' , -1 )

       

      myDate is a "Date" type. In labels of each class shown in pivot table i have something like this :

       

      40915 <= Date < 40919          40919 <= Date < 40923     ...

       

      i need to customize labels. for example something like :

       

      07.01.2012                              11.01.2012

       

      i need to mention that ( 07.01.2012 ~ 40915 ) and ( 11.01.2012 ~ 40919 ).

      at least i need one of the following forms:

       

      07.01.2012 <= Date                 11.01.2012 <= Date

       

      or

       

      07.01.2012 <= Date  < 11.01.2012               11.01.2012 <= Date < 15.01.2012

       

      how can i do that?

      thank you so much.