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...
Quote from: Bohor2Gannes on 11 Feb 2016 03:52:51 PM
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.
thank's a lot !! It's working !
Regards :) :) :) :) :) :) :) :) :) :) :) :) :) :)