Hello
I have couple columns which I would like to make a summary table using EasyMorph. when I use pivot action, I dont get the format I want. does anyone know how to make pivot with the format below?
However, if you need that pivot table in an Excel spreadsheet, the approach should be different:
Have a raw data sheet in the Excel spreadsheet.
Have another sheet with a pivot table that uses the raw sheet data as the source (make sure to tick “Refresh on open” in the pivot table properties).
Use the “Export to Excel” action in EasyMorph to replace the raw sheet data.
Thank you so much. I actually figured it out , but your way is more complete. I also used year month as I needed it this way. So here is the follow up question. what if you want to group previous months or years, and just have the current month shown as independent?
In the above example I have each month showing separately in the pivot. I want to show previous months in one group (sum) separated from current month .