Hi! I am having trouble in changing the layout of the pivot table. What I currently have is this:
Capture.PNG
and I want the voucher field which contains numbers such as PV-210, PV-164 etc in front of each of the dates each such number belongs to.
For example, I want the number PV-210 to be in front of the date 24-07-2014 and so on.
Regards
While in the PivotTable go to Design tab, then Report Layout and select Show Tabular Form
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
thanks a billion.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks