I am using the Superstore dataset, and I have 2 columns: "Order Date" and "Sales"
I created two calculated fields: "Sales 2016" and "Sales 2017", which are the total sales for those respective years.
Then I created the calculated field called "YOY 2017', which is:
[Sales 2017] - [Sales 2016] / [Sales 2016]
But when I try to drag the "YOY 2017" calculated field onto the workspace, nothing at all shows up. Why???
Hi @Rohan Garg
You can do this without writing any calculated fields at all, because in the real world you will have to keep adding calculated fields as more data (years) are added in the future.
You could do this:
or if you just wanted a single number I've done that in the workbook as well.
----------------------------------------------------------------------------------------------------------------
Please upvote my helpful replies & choose Select as Best Answer if it really is the best :)
