ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Use icon sets relatively in a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/260159-use-icon-sets-relatively-pivot-table.html)

Darlene[_2_]

Use icon sets relatively in a pivot table
 
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

Herbert Seidenberg

Use icon sets relatively in a pivot table
 
Excel 2007 PivotTable
Arrow Icons
Change from previous value.
http://c0718892.cdn.cloudfiles.racks...03_29_10a.xlsx
Pdf preview:
http://www.mediafire.com/file/x1h5jqnyjwy/03_29_10a.pdf


All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com