Excel Complex Dashboard Issue

[LucyK]

Hi All,



I was looking for some advice on a dashboard I am working on.



I have created a dashboard with Pivot tables and graphs, along with running totals at the top that are using a sum formula based on cells within a pivot table.



The issue I am having is every time I filter the pivot tables the running totals at the top are incorrect as they are pulling from cells that are changing every time I filter using the pivot tables and slicers.



I can't seem to understand how I stop that from happening and only have the required totals at the top.



Example:

When the pivot tables are not filtered by totals are correct:

Open = 396

Closed = 367

Affected = 56

Not affected = 4



However, when I filter using a slicer my open totals will move to close as an example and my affected totals seem to double.



Any help would be appreciated.



thanks

Lucy

 

[Jeffrey Mahoney]

I would need to see your formula and I would need you to tell me what rows your pivot table DATA occupy (not including headers).

 

[Jeffrey Mahoney]

Do you have your formulas looking at the Grand Total at the bottom? If so, turn off the grand total row