Capture1.JPG
As stated in the title, i wanna make the field to be consistent. For instance, Yes, No, and others in every category. Google Sheets btw, how do i do that?
Capture1.JPG
As stated in the title, i wanna make the field to be consistent. For instance, Yes, No, and others in every category. Google Sheets btw, how do i do that?
Select one of the cells in the pivot table that is in the category column.
Right-click -> Field Settings
Layout & Print
Check box - 'Show items with no data'
Its google sheets, not microsoft excel
I don't believe Sheets has that option, so you'd have to make the Category field a column field instead.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks