According to the official information, it appears that HCell supports pivot tables, but the problem is that the way to access the pivot cell isn't explained. The HCell works the same as Excel in some ways, because after all, it's pretty much a copy of Excel. In this case, use the Excel guide into pivot cells and then use the same guide to work on HCell. Use the guide presented by the Microsoft Office help pages.