I have a database which accumulates monthly revenues in each line. Every month, the resulting revenues are added to the bottom line. Is there a way to calculate growth of a certain month compared to the same month of the previous year (i.e. august 2014 over august 2013)? I've seen there is a PREVIOUS formula, but this one brings the previous line, not twelve...
Please check the example attached, focusing in the widget showing a grid.
In this dashboard, we added calculated fields in order to get the Month, and discriminate the field "Wage" between the "Current Year" and "Previous Year".
Then, we aggregated the information by month summarizing the "Current Year" and "Previous Year" value.
Finally, we added a calculated field post pivot table processing in order to get the growth related to the previous year, indicating the growth using conditional formatting and percentage formatting.
Note that the dashboard has the local file referenced embedded, so the easiest way to open the dashboard is unzip it (you'll get a file named 'Wage Growth.rplus'), sending it by mail, and using "Open In" ReportPlus from mail application.
I hope this can help you.
I will check it!!!! Thanks for your prompt answer.
I did as suggested (unzipped and emailed the file). When I open with reportplus, it just says that it will overwrite a winmail. Then, nothing happens. The dashboard doesn't open as expected. Am I doing anything wrong?
When you email the .rplus file and open it with ReportPlus, you should see the dashboard opening, or at least stored in ReportPlus.
If you have a dashboard already opened, you can find the new dashboard in the main screen.
Try to import the dashboard to ReportPlus again. ReportPlus might ask to overwrite the dashboard and the local files (you'll see this if the previous opening worked).
In any case, if you could send me screen captures of the moment in wich you choose ReportPlus from the email application, or the messages shown, that would be helpful.
As far as I know, Winmail is a file viewer, maybe, this app is ofering to open your file instead of ReportPlus, in that case, you have to find ReportPlus on the list (usually scrolling horizontally in the app's list shown).
Let me know how it goes.
I did it. The way to get the file was through gmail (it seems like you cannot easily access certain files on ipads anymore in newer iOS versions). I checked the widget and now I understand how to do it. Thanks a lot.