The solution will be to use the LibreOffice Calc module that allows to create pivot tables on registered data sources.