PDA

View Full Version : pivot help



atuljadhavne
06-21-2012, 02:13 AM
Dear Expert

I have Price list of various product for 12 month for different location, than i make a pivot
in report filter i select Location
in column i select Month
in row i select prodict
in value i select product price
so i get result as below

Location:- Baroda
Product Jan / Feb / Mar / Apr / May / Jun / July
Product 1 2 / 3 / 8 / 5 / 2 / 3 / 6
Product 2 5 / 6 / 6 / 9 / 4 / 5 / 5
Product 3 6 / 9 / 5 / 5 / 9 / 5 / 6
Toal

Now what i want, i want one image which show price down or up symbol like up ward aerrow or down ward aerrow from prev month


is this possible in pivot if not than how can i do this, condition formation not working in this, in this when i refresh it show wrong direction.

CatDaddy
06-21-2012, 01:14 PM
post a sample workbook and the code you have so far and we will be able to help you much more easily