BloodyBill
New Member
- Joined
- Oct 5, 2020
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
I have a pivot table with many columns. Imagine 50 salespeople (not the 4 shown). I have row grand totals.
I'd like to compare Bill's sales (10 apples) against the row total (18 apples) side-by-side.
I could hide the other columns, which preserves the calculation of the grand total. The problem with that is that it is clunky and inconvenient with so many salespeople/columns.
I'd rather just click Bill on a slicer, but that removes everyone else's sales numbers from the grand total. Now it looks like Bill sales of 10 apples were the same as the total sold (instead of 18).
Is there a way I can...?
I'm wondering if there's a solution that uses a helper column separate from the pivot itself?
Thanks,
Bill
I'd like to compare Bill's sales (10 apples) against the row total (18 apples) side-by-side.
I could hide the other columns, which preserves the calculation of the grand total. The problem with that is that it is clunky and inconvenient with so many salespeople/columns.
I'd rather just click Bill on a slicer, but that removes everyone else's sales numbers from the grand total. Now it looks like Bill sales of 10 apples were the same as the total sold (instead of 18).
Is there a way I can...?
- keep a grand total column with an actual grand total
- and use a slicer to conveniently hide everyone but Bill
I'm wondering if there's a solution that uses a helper column separate from the pivot itself?
Thanks,
Bill