pivot tables, slicer and charts update

[aarona]

Hi,

Not sure if this idea is feasible.

Let's say i have a pivot table chart with slicer. I want the slicer to change the Total from Count to Sum (or vice versa). Is this even possible?

Any help/ideas will help. Thanks!

[dflak]

I answered a similar question in another post. The way to do this is overlay the pivot table results with named dynamic ranges and have the ranges point to either the count or the sum depending on the value in another cell.

I can show you how to set this up if you provide a sample worksheet.