Format rows pivot table

[Bohor2Gannes]

Dear all,
I have a list with the correct format for earch column... (date, amount...) but when I convert the list into a pivot table... I lost everything.

How can I apply a format to the rows (not the measures..)
in my example I have the last sales dates, the  amount, in rows...
thanks in advance...

[Lynn]

Dear all,
I have a list with the correct format for earch column... (date, amount...) but when I convert the list into a pivot table... I lost everything.

How can I apply a format to the rows (not the measures..)
in my example I have the last sales dates, the  amount, in rows...
thanks in advance...

Click on your rows and change the source type to Data Item Value (instead of member caption). Then use data format to display as desired.

[Bohor2Gannes]

thank's  a lot !! It's working !
Regards :) :) :) :) :) :) :) :) :) :) :) :) :) :)