Consulting

Results 1 to 2 of 2

Thread: pivot help

  1. #1

    Thumbs up pivot help

    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.

  2. #2
    VBAX Expert CatDaddy's Avatar
    Joined
    Jun 2011
    Posts
    581
    Location
    post a sample workbook and the code you have so far and we will be able to help you much more easily
    ------------------------------------------------
    Happy Coding my friends

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •