My pivot table randomly stopped showing information. I have an older version of the document saved and it does show the information in that version. I have not edited these tables or sheets in any way in my update and I cannot figure out why the information will not show. I have the same result even if I copy and paste the working pivot into the qvw with the broken pivot. Do you have any idea what could be causing this?
The table viewer still shows the data in the tables.
Unfortunately that did not work. It actually affects all 3 pivots on the the sheet. There are then tabs to show/hide the pivot depending on which you click. It would seem like the filters somehow got messed up but I have not been able to identify anything.
I just figured it out and what you suggest is basically what I did. I unhid fields and saw that a slider was no longer fitlering. Somehow the trigger on the slider got deleted. Once I replaced it everything worked.
Both the dimensions and expression were showing blank.