http://chandoo.org/forums/tags/tutorial Ask Excel and Charting Questions, Muse about Visualizations, Learn and Share - Discussion Forums - Chandoo.org en-US Fri, 24 May 2013 01:09:43 +0000 http://bbpress.org/?v=1.0.1 q http://chandoo.org/forums/search.php http://chandoo.org/forums/topic/pivot-table-show-a-sub-total-as-a-of-the-grand-total#post-2341 Tue, 13 Jul 2010 15:05:10 +0000 NeverHappyMike 2341@http://chandoo.org/forums/ <p>@Oldchippy: thanks for the link. I can imagine I'll be using that page quite often.</p> <p>@Hui: that was something i tried but didn't manage to make work. Recently though I have learnt that you can use the same category in the values field more than once. Maybe that will be how I can make it work for me.</p> <p>Thanks again for you input. </p> http://chandoo.org/forums/topic/pivot-table-show-a-sub-total-as-a-of-the-grand-total#post-2333 Tue, 13 Jul 2010 00:30:18 +0000 Hui 2333@http://chandoo.org/forums/ <p>Mike<br /> Have you tried<br /> Right Click on the Field you want to see<br /> goto <strong>Value Field Settings</strong><br /> <strong>Show Value as Tab</strong><br /> Show Values as <strong>"% of Total"</strong> or <strong>"% of Column"</strong> </p> http://chandoo.org/forums/topic/pivot-table-show-a-sub-total-as-a-of-the-grand-total#post-2329 Mon, 12 Jul 2010 19:48:18 +0000 oldchippy 2329@http://chandoo.org/forums/ <p>Hi,</p> <p>Here's a good place to start learning about Pivot Tables take a look in the tutorials here</p> <p><a href="http://www.contextures.com/xlPivot01.html" rel="nofollow">http://www.contextures.com/xlPivot01.html</a> </p> http://chandoo.org/forums/topic/pivot-table-show-a-sub-total-as-a-of-the-grand-total#post-2319 Mon, 12 Jul 2010 12:28:10 +0000 NeverHappyMike 2319@http://chandoo.org/forums/ <p>I've done some searching around and get the imporession this was something quite a few Pivot table users have asked about. A possible way to do it is by adding helper columns and making the calculation there. I'm still working on it, but if anyone has ideas let me know.</p> <p>Thanks<br /> Michael. </p> http://chandoo.org/forums/topic/conditional-formating#post-2315 Sun, 11 Jul 2010 20:43:13 +0000 oldchippy 2315@http://chandoo.org/forums/ <p>Hi,</p> <p>More tutorials here</p> <p><a href="http://www.contextures.com/xlcondFormat01.html" rel="nofollow">http://www.contextures.com/xlcondFormat01.html</a></p> <p>&amp;</p> <p><a href="http://excel.tips.net/E186_Conditional_Formatting.html" rel="nofollow">http://excel.tips.net/E186_Conditional_Formatting.html</a> </p> http://chandoo.org/forums/topic/conditional-formating#post-2314 Sun, 11 Jul 2010 07:16:33 +0000 Hui 2314@http://chandoo.org/forums/ <p>Have you had a read of some of the posts by Chandoo?</p> <p>Like<br /> <a href="http://chandoo.org/wp/2009/03/13/excel-conditional-formatting-basics/" rel="nofollow">http://chandoo.org/wp/2009/03/13/excel-conditional-formatting-basics/</a><br /> &amp;<br /> <a href="http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/" rel="nofollow">http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/</a> </p> http://chandoo.org/forums/topic/conditional-formating#post-2313 Sun, 11 Jul 2010 06:41:51 +0000 gopalakrishnarao1 2313@http://chandoo.org/forums/ <p>How to do conditional formating, I am trying to do the conditional formatting. Please help. Please give the link if possible in a video tutorial.</p> <p>Thanks in advance for the solution provider. </p> http://chandoo.org/forums/topic/pivot-table-show-a-sub-total-as-a-of-the-grand-total#post-2260 Mon, 05 Jul 2010 14:01:08 +0000 NeverHappyMike 2260@http://chandoo.org/forums/ <p>Hi all</p> <p>I'm struggling to make a PT show me the data how I need to present it. My 15 colleagues are chosing from 30 questions. I then use a PT to help me see what questions have been chosen by which. However, I also need to see how 'popular' each question has been: ((NumberOfColleagues/TotalNumberOfColleagues)*100).</p> <p>As I'm using PT's a lot I would really like to be able to manipulate them better, as I'm sure I'm only just scratching the surface of their usefullnes. I've reason to believe people set up blank columns, etc for such a reasons, so they can add calculated fileds in where needed - but how to add these calcualted fileds is the missing link for me.</p> <p>Michael. </p>