I have a database of sold articles and I want to export that data by the sub summary sales of each product from table view. My table view shows the data correctly (see first picture), so I assume my sub summary is set up correctly. However, if I export the data through File/Export Records as an Excel file grouped by the same sort criteria I use in the table view to get the sub summary, I will get an Excel file that does recognise and group my articles correctly, but the sub summary column only shows the total over all articles. How do I get it to show the sub summary for each article as it does in filemaker?
I'll attach images of the table view in filemaker, the export window and the resulting excel file.
Thanks and best regards,