Prev: Pivot table grand total location
Next: Caluclating days past due
From: Darlene on 29 Mar 2010 14:12
Hi All!
I can use icon sets for certain things, but am unable to figure out
how to use them with my existing data.

I have a pivot table that may list sales from Quarter 4. If you expand
that level of the pivot table you would see the monthly, weekly and
daily sales that constituted Quarter 4. But I want to show icons to
give a visual cue if Q4 was up from Q3.

I would need to do this again in the future to see if Q1 is up from
the previous years Q4.

Sample Data would be:
Week Sales (want to see icons in this column, beside numbers)
4 20
3 15

I want to know at a glance if the 20 is higher than the 15;

Thanks
From: Herbert Seidenberg on 29 Mar 2010 15:31
Excel 2007 PivotTable
Arrow Icons
Change from previous value.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_29_10a.xlsx
Pdf preview:
http://www.mediafire.com/file/x1h5jqnyjwy/03_29_10a.pdf
 | 
Pages: 1
Prev: Pivot table grand total location
Next: Caluclating days past due