Hi All,
i've month wise sales data at different dayparts which i regularly update every month. I need a calculated field which calculates the difference of last 2 month columns. So when i update a new month, it should take the latest month & previous month difference. Data as attached.
Last edited by raja_puligadda; 01-08-2017 at 07:52 AM.
Please add your expected outcomes to the sheet you have attached.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you for the reply..attachment revised
I would use a vertical arrangement and convert the range of data into a table with an added calculation for the difference between months. In addition, change the dates in column A to be real dates that Excel recognizes. In the new column (column D) add this formula and fill down.
Formula:
Please Login or Register to view this content.
Make the Pivot Table source the table that is created above. That will allow an easy refresh to accommodate new data added to the table.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Firstly insert table range in main data.
I use between your Pivot table last & last butone column data in another cell with formula, when ever you add data in your main data table & in Pivot table click on "Refresh All", accordingly change the range with last & last butone column data. See attach file.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Don't know how to open the attachments. It is in some php format.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks