So I am making a dashboard which I have to use different pivot tables and then get a total from them. My problem is I want my total column to match the formatting of the pivot table if there is data, and to be blank if there isn't data. I was going to use if statement to get total but at a loss for how to match the formatting. Another side note is the pivot table will grow with each day 