Hi!
I'm creating a financial report including the turnover, growth, growth %, cumulative of the tov and cumulative of the growth.
The data available is the turnover which I used to calculate the growth over 2 years (first calculated field).
Now my question: How do I use this calculated field (growth) to create a second calculated field (cumul of the growth)?
Thanks!
Last edited by VinceWlms; 07-22-2020 at 06:54 AM.
Hi
please post a sample sheet as described in the yellow banner
I am not sure what you expected for results, so I just assumed you wanted a cumulative number for
growth.
Look at the attached file and see if this is what you wanted.
J4 =SUM($I$4:I4) and drag down.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi, thanks for the reply! Your outcome is indeed what I'm looking for BUT the problem with your solution is that when I filter in the pivot table, these values change. So what I need is not a sum of a range of field, since these fields change when filtering the pivot table. Do you know how to achieve this?
Can you make a calculated cell with the formula i made?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks