Totals at the Top of a Pivot Table

Ask the Community
,
1

In workshop, you can build a pivot table using the pivot table widget. The pivot table widget puts the totals at the bottom of the pivot table. Is it possible to put the totals at the top of the pivot table and, if so, how do you do it.

Thanks,

Len Stringer

2

Hi Len, please excuse the delayed response. As far as I’m aware, showing totals is a toggle that only displays it at the bottom or not at all. If you’re okay with displaying just one week’s totals at a time in a metric card, I’ve got a work around that uses the filter output to feed some function-backed variables to populate metric cards—happy to walk you through that in more detail.

Ray