Share via

Slicer & Distinct Count Issue

Anonymous
2018-07-31T10:21:39+00:00

Hi,

I have a set of pivots (with graphs) that are connected to slicers.

I am adding a new Pivot (with graph) that is created using distinct count, the issue I have is that the existing set of Slicers are not showing the pivot table I created to show the Distinct Count. As a consequence I have not been able to connect all of the pivots/graphs.

All pivot tables are pointing the same table of data.

Does anyone know if its possible to connect the new pivot to the rest of them?

Any help much appreciated

E

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Ashish Mathur 102K Reputation points Volunteer Moderator
    2018-08-01T00:27:57+00:00

    Hi,

    May be while selecting the data source for your second Pivot Table, you select one row/column less/more.  Take another look at the source data range of your second Pivot Table.

    Was this answer helpful?

    0 comments No comments