Pivot report with fields from main form and subform

Pivot report with fields from main form and subform

Greetings, hope find all good and safe!

I have a form related with a subform. I need to create a report type pivot, but only the fields from the main form appear (it seems that it is a known limitation), someone know alternatives to this?

Thanks in advance.