Last Year and Current Year data comparisioj
Hello Everyone,
I need to create a report which shows up data of the last year and current year annual units and its differences.. I am able to fetch the data for the last year and current year using pivot table . Since Annual unit is an single column how to differenciate current year and previous year data. Using pivot table measure column i was able to difference data but not able to get the difference. My concern is do i need to develop combined analysis one for current year and other for previous year .
Kindly need help in creating this report. Have attached the screen shot of the report created using pivot table.
0