I want to create widget in dashboard that shows the sum of sales 3 months ago.

If I use the relative filter (this logic applies to pivots and charts as well) such as "Last 3 Months" it aggregates the Sales $ for the three months.

If current month April 2015, then the relative filter will aggregate total sales for Feb, March and April 2015.

However, what I would like is the total sales for the month of Feb 2015 only. The reason I am using relative filter is because next month which is May 2015, the widget should show total sales for Mar 2015.

The above is also useful for snapshot/non-aggregate type tables such as financial balances and inventory.

The widget I am showing is current month sales i.e. April 2015 and a % different to the sales 3 months ago which is Feb 2015.

Obviously one option is to create a query to do the above. However, is there another option to do this by using the drag-and-drop interface?

Thanks

Sunil