-
Re: Calculated field in pivot table
Sunny Talwar Aug 28, 2016 3:49 PM (in response to Tom Fack)Is this what you want:
(Sum([Invoice Value]) - Before(Sum([Invoice Value])))/Before(Sum([Invoice Value]))
-
-
Re: Calculated field in pivot table
Sunny Talwar Aug 29, 2016 5:48 AM (in response to Tom Fack)Is this always going to be a comparison between two years or could there be more than 2 years in this chart?
-
Re: Calculated field in pivot table
Tom Fack Aug 29, 2016 5:54 AM (in response to Sunny Talwar )It's always going to be a comparison between two years.
-
Re: Calculated field in pivot table
Sunny Talwar Aug 29, 2016 8:22 AM (in response to Tom Fack)Would you be able to re-run the application for me with a new table in it?
Dim:
LOAD * INLINE [
DIM
1
2
];
-
Re: Calculated field in pivot table
Tom Fack Aug 29, 2016 9:05 AM (in response to Sunny Talwar )Sure. See attachment.
-
Re: Calculated field in pivot table
Sunny Talwar Aug 30, 2016 8:36 AM (in response to Tom Fack)My bad Tom, would you be able to run it with this:
Dim:
LOAD * INLINE [
DIM
1
2
3
];
I underestimated the need for the 3 in the DIM field. I apologize for asking over and over again to do this
-
Re: Calculated field in pivot table
Tom Fack Aug 30, 2016 8:57 AM (in response to Sunny Talwar )No problem Sunny. It's you that is helping me so I don't mind.
-
-
Re: Calculated field in pivot table
Tom Fack Aug 31, 2016 3:45 AM (in response to Sunny Talwar )That's 100% what I was looking for. Thx.
I consider the expression you wrote rocket science
-
Re: Calculated field in pivot table
Sunny Talwar Aug 31, 2016 4:50 AM (in response to Tom Fack)Hahahaha, the good thing is that I was able to help you out at last. and I ended up needing only DIM 1 and 2. Sorry to make you rerun the app with 1,2, & 3
-
-
-
-
-
-
-
-
-
-