I use pivot tables a lot.
But I cannot figure out what make certain field to go to Rows, while others to Values when I click the tick box through mouse.
Normally I always want that whatever field I select go to the Value section.
Because some don't, I have to manually drag and drop them every time.
Any way, I can customize this behavior of field?
Dont want Percentage to go to Rows, it should go to Value area like Numbers does (shown below)
BTPia.png
Following is what I want ideally, field to go to Value section, instead of Rows.
b3fOl.png
Bookmarks