How to Analyze Aggregated Data for Elections

We built all the tables using to this dwell data so the I mean the skeletons now the problem was when op came into picture which all the tables overshot the pivot tables were not building it was recognizing op as a new party. We had not accounted for that so it took about an hour or so to correct the tables based on because op was introduced. This happens almost every election because for because we beforehand we also have to keep in mind who are the alliances so this is a huge problembecause these same people who were in alliance today might have not been in alliance the last time. there is an error then please make sure it's zero don't show some formula we don't throw an error