Troubleshooting Group/Ungroup feature in pivot tables

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi team,

Hoping for your assistance once again.

I have been able to consolidate expressions and group them in my pivots ($ vs qty). However it seems to fail with this table.

Re: Troubleshooting Group/Ungroup feature in pivot tables

boorgura — Tue, 10 Apr 2018 18:49:41 GMT

You lose the ability to cycle thru expression group when you pivot a dimension across.

As per my knowledge, I dont think there's a clean solution.

However - you can Add a dummy expression (='') with blank label (space), and reduce the column width to minimum.

Definitely not a clean solution!

PS: the dummy expression should not be grouped along with the other expressions