Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Would like to merge cells in Pivot table, sample design attached below for reference.
Basic Pivot design:
Requirement is to merge cells and expected to design like,
Would like keep Abc - Total & Fun - Total expressions as columns and not to show duplicate for each rows.
Can you please check your screenshots, I can't see any image.
Maybe you are using links to images that can't be accessed by unauthorized users.
If possible, please also post a small sample QVW.
Plz check now. Attached the screenshot..I did the design in Excel to share with this group. I dont have any QVW file.
That's not possible. You can try calculated dimensions instead of expressions, but then they would show up on with the other dimensions on the left side of the pivot table. A calculated dimension would look something like =aggr( ...original_expression_here... , Col1, Col2, Col3, Col4).