Troubleshooting Group/Ungroup feature in pivot tables

[Anonymous]

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.

[boorgura · Accepted solution]

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