Dashboard Trouble

**jason.hampton** · 06-21-2017, 03:22 PM

Group,

I am having an issue with the dashboard and pivot chart I've created.

When you use the slicer located on row AC1, the "Individual Verification Status" calculation doesn't work correctly in cells Z22:AB27.

Any ideas what I am doing wrong?

Unit 3 Generator High Vibration RCA_Verification Matrix.xlsx

**Syrkrasi** · 06-21-2017, 04:29 PM

The Slicers on the left-hand side appear to had lost their report connections.

Fix: Simply click on the Individual Verification Status Pivot Chart and re-select the slicers you need (see attachment)

**jason.hampton** · 06-21-2017, 04:54 PM

Syrkrasi,

Thank you for the rapid reply. I must be doing something wrong. I've selected the "Individual" chart and then selected "Ron Lane / Dave McCormick; and received the same status of 100%. This should only be 50% because they have 3 verified and 3 open.

**jason.hampton** · 06-21-2017, 05:36 PM

A little more feedback.... The slicers on the left were created from my Pivot Table. The "Individual Status" slicer was created from the Individual Status pivot chart. The second chart updates with that slicer.