Hi,
I want to create calculated fields for my pivot table showing me the % difference between email signups from the following day. Tried using a calculated field but it only works for fields and not values in the fields.
So basically, I have a field called status with a bunch of values. Then I have count of email dress for that day. I'm not sure how to go about calculating it
Any ideas?
can you show us what you want to see? I reckon you either need a calculated item rather than field, or to show a sum as a % of the next value
Josie
if at first you don't succeed try doing it the way your wife told you to
I guess it would look something like this. so for the row "Oct", the "% change" would be the % difference between "Sep" and "Oct" "gallery_page" .
Last edited by Peeekay; 02-11-2013 at 10:36 AM.
add the count again then change the field settings to show values as '% difference from' and choose 'previous' as the base
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks