row field

  1. P

    Pivot table: Row fileds with multiple options

    Hello guys I have a table looking like this: <tbody> Row A B C Sales 1 1 0 1 22 2 0 0 0 103 3 1 1 1 113 4 1 1 1 77 5 1 0 0 109 6 0 0 1 101 </tbody> And from this table I create a pivot table. The result I need to get is this: <tbody> A B Sum - Sales 0 0 150 1 102 1 0...
  2. R

    Check if forfields present in pivot table, then remove

    Hi guys I've got a pivot table setup. The user can then play around with it i.e. drag and drop page fields into rowfields and columnfields and vice versa. Now I want to write a macro that checks if there are any rowfields or column fields present in the pivot table, and if so then relocate...

Some videos you may like

This Week's Hot Topics

Top