+ Reply to Thread
Results 1 to 2 of 2

Pivot Table | Use previous value in calculated item

  1. #1
    Registered User
    Join Date
    04-20-2005
    Posts
    48

    Question Pivot Table | Use previous value in calculated item

    I would like to create a calculated item based on the previous value in the pivot table.

    In my mind the calculated item formula would be: =Col_A - (Col_A[-1] * 100) thus giving the following output:

    Col_A = Original Data
    Col_B = Delta from previous value times 100

    Col_A------Col_B-----
    ----6------------0--------
    ----9------------300----
    ----10----------100-----

    Is this possible?

    Thanks,
    JC

  2. #2
    Registered User
    Join Date
    04-20-2005
    Posts
    48

    Re: Pivot Table | Use previous value in calculated item

    I've tried adding a "Difference From" field to the pivot table, but then I'm not able to use that field in a calculated item.

    Any other ideas?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1