I have a Pivot table, however, I do not like the display format. I am not sure how to change it.
See the attached sample file.
Thanks
I have a Pivot table, however, I do not like the display format. I am not sure how to change it.
See the attached sample file.
Thanks
I dont know how to do this in a pivot table but I can do it in a formula.
Let me know if this works for you..
Last edited by day92; 05-20-2011 at 06:57 PM.
In 2010 there is Report Layout dropdown that gets very close to what you want.
Look at
http://office.microsoft.com/en-us/ex...001034632.aspx or
search for Report Layout using 2003 Pivot Tables
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks