I manage to create the table using a straight table, but without the Previous Month and Previous Year. How can I add these two rows into the same table? Currently I'm creating another tables for these two rows, but the user cannot export it into a single excel.
Re: Previous Month at the Bottom of Straight Table
To get this done, you have to modify your data model to add strings 'Previous Month' and 'Previous Year' to dimension. For getting metrics of above dimension values, need to concatenate their aggregated values to oringinal metrics table. And this procedure can become complex depending upon your existing data model structure.
But, as you have stated above, 'you are currently creating another table for two rows'. I would suggest you to go with the same and in order to export both tables/charts to same excle sheet, there is workaround available.
For this, you can refer below excellent post by Stefan WALTHER: