Table Columns - Custom metrics date ranges
I am trying to create a single table to show the different data for a dimension across different date ranges. Is this possible through creating customized metrics with calculated metrics?
E.G. I need one table for dimension: product sku with metric: product revenue, but I need columns with product revenue for the current month, last month, prior period and year to date. Does anyone know if its possible to do this in one table?
I can create multiple tables with the specific date ranges, it always has to show the column with the dimension, if I could turn off visualisation of the dimension and just show the metric data then I could align the columns to show the data sequentially, otherwise its not as easy to understand the data.
Any suggestions would be great.