Simple answer, yes, just use a Lookup.
Though it would help to know how your data is defined to be able to provide the correct calculation to you.
This can be done using window calcs and lookup-ups.
First though, may I know how you are intending to use your data? Are you planning on plotting this as a table in this way or, are you going to be creating a visual, and what calculations do you have in mind, and finally, is this the only data in your set? This would be useful to know if you are going to build-out a little more as window calculations can affect this if they are not properly scoped.
So basically I also have the budget information, so I wanna find the
difference between budget and sum of first three Q actual spent , then
comparing it with the last Q forecast spent, to virtualize the likelihood
of under / over spent.
Do you mind give me some idea of how to use the calculations as you
mentioned to compare the sum of first three quarters and the last quarter.
On Sat, Sep 22, 2018, 10:18 AM Steve Martin <firstname.lastname@example.org>
The attached workbook demonstrates the use of a lookup and, when using it in a calculation for a comparison.
As a matter of interest, do you happen to work for a travel firm?
823350 - Lookup example.twbx 2.4 MB
Thank you for your help! feel good to learn sth new today!
And no, i am just planning data with some ideas i didnt work for a travel firm