Use icon sets relatively in a pivot table

D

Darlene

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rank in Pivot Table 4
IF formula with certain conditions to achieve a desired value 2
Pivot table-show Q3 and Q4 with non filtered Total 0
Pivot table -Show Q3 and Q4 with non-filtered Total 0
Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
changing year grouping in pivot table 4
I have Text in a Colunm but want to sort ... 4

Top