By no means is 400,000 cells a "big dataset". I would put the dividing line somewhere near 2 million rows.
Zoho Sheet (http://sheet.zoho.com) and Zoho Reports (http://reports.zoho.com) have pivot tables since 2008. While Zoho Sheet can support 1 million cells, Zoho Reports has customers having 15-20 million rows.