I'm not sure why it's so hard to find an answer to simple things but it is. Not one example exists. Apparently, no one thinks like me.
I have a bunch of columns I created: Date Columns and Text Columns. The Text Columns contain either TRUE or FALSE. Three column headings: R1, R2, and R3 with each column containing TRUE or FALSE. I simply want a total of TRUE values for each column heading in a pivot table. You pull 1 column into Row Label and Values, no problem. You pull two columns in, EXPLOSION. Values no longer correct. Not sure why but that's what happens. Trying to figure out how many TRUEs there are for each Column heading. Simple right? Wrong. See attachment. "Master" is my source and "Latest" is my pivot.
It's kind of crazy but all examples I've come across absolutely no one has a data set up like mine where they show how to do this.
Bookmarks