Its been 3 years since this blog is launched. well, slightly more than that as the very first post was published on July 1st, 2004, my first day at IIM Indore. What started as chronicles of an engineer struggling in a b-school later transformed in to a full-time commentary on business, advertising, technology and life in general. I am happy to have maintained the blog this far. Hopefully this will last for few more years to come.
To celebrate the 3 years, I have modified the template, made it compatible with 1024*800px screens, added another column for ads, removed the yellow color theme and added a bold header image. Also, provided a google custom search engine to exclusively search PHD. Try it, its very easy to locate any of those 450+ posts meeting your search criteria. Hopefully more changes will happen in the next few weeks to make this place a little better for browser viewing. Suggest any widgets, features that you want to see here, I will try to add them. Happy Weekend!
Related: Read Welcome to PHD post
5 Responses to “Preparing Profit / Loss Pivot Reports [Part 2 of 6]”
[...] Preparing Pivot Table P&L using Data sheet [...]
[...] Preparing Pivot Table P&L using Data sheet [...]
[...] Preparing Pivot Table P&L using Data sheet [...]
I am not getting sound from the videos. I have checked all the settings and spent several hours searching the Internet to no avail.
Has anyone else had this problem?
Is there anyway to get the Grand Total to be broken out in the same fashion as the items above it? For instance, if you have in column 1, widget a, widget b, and have their sales by month in column 2, I'd like to see the grand total also be by month, for widget a & b combined.
I can't get anything other than a single line for the grand total, rather than the same format as the data above.
Widget A Month Sales
Jan 100
Feb 200
Widget B
Jan 150
Feb 250
Grand total - here I would also like to have Jan, Feb.
Jan 250
Feb 450