PDA

View Full Version : Pivot table priority issue



Mohans052
10-17-2014, 01:36 AM
Hi,

Thanks for looking at my query.
Does anyone knows how to prioritze row based upon the cell value. That is

1. I have pivot table in sheet 2 which is linked to sheet 1. I am using pivot table as report.
2. I have a coloumn in pivot table as urgency which is linked to sheet 1 urgency .
3. Everyday i need to enter multiple row data in sheet1 which will replicate in pivot table in sheet 2
4. If i select high priority in sheet 1 , it shows high priority in pivot table in sheet 2 as well but i would like to highlight it in red and bring on the top row of the pivot table.
5. If i select medium priority in sheet 1, it shows medium priority in pivot table in sheet 2 as well but i would like to highlight it in amber and bring below the high proprity row.
6. If i select low priority in sheet 1, it shows low priority in pivot table in sheet 2 as well but i would like to highlight it in green and show below medium priority row.

Please help me guys,
~Thanks in advance

Bob Phillips
10-17-2014, 02:02 AM
What do you mean by ... If i select high priority in sheet 1 , it shows high priority in pivot table in sheet 2 as well. I don't understand, how are you doing that.

Mohans052
10-17-2014, 02:58 AM
I have dropdown box in sheet 1 which have option like
* high priority
* medium priority and
* low priority
I have pivot table in the sheet 2 which link to sheet1 dropdown box

thanks