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.
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.