Earlier quoted context omitted.
I like AbiWord, but for some reason it keeps crashing on my Arch Linux system. Between Libre Calc and Excel, I've always had to revert to Excel for its Pivot Table features. Libre Calc has thus far made a very weak stab at that for me.
I think Libre Calc has a pivot table feature though. Are you missing a feature within the pivot table options?
Yes, Calc does have pivot tables, but it is very limited. Even the number of levels (dimensions) that you can nest was inadequate the last time I checked.