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.