What can i do to publish comparative data in my dashboard? for example, in my notes to FS, i published the period ending and reporting entity. For my cash and cash equivalents, if i select Jan 2019, the comparative month (Jan 2018) shall also appear alongside with it? and if i select Feb 2019, Feb 2018 data will appear and so on..
There are multiple ways to do this.It all depends where your source data is. For example you can create a list with two entries i.e., Current Period and Prior Period and write IF else statement to pull the data from the respective source modules.
In addition to my previous query, what if part of the client's requirement is to be able to see the quarterly, half year and yearly comparative data. I was able to derive the monthly comparative but upon discussion, the quarterly and annual should also be part of the selection. is there a way to merge the monthly, quarterly and yearly in the selection pane to show the comparative of them too?