Help with dynamic table

%3CLINGO-SUB%20id%3D%22lingo-sub-1457470%22%20slang%3D%22en-US%22%3EHelp%20with%20dynamic%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457470%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3EHow%20to%20calculate%2C%20in%20the%20dynamic%20table%20itself%2C%20a%20column%20with%20the%20division%20of%20the%20results%20obtained%20in%20the%20table%20itself%20(example%20average%2Fmaximum)%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1457470%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1457506%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20dynamic%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457506%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F696919%22%20target%3D%22_blank%22%3E%40whnunes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20little%20more%20description%20would%20be%20helpful.%20How%20exactly%20are%20you%20using%20the%20term%20%22dynamic%20table%2C%22%20for%20example%3F%20Is%20it%20a%20standard%20Excel%20Table%20(which%20is%20dynamic%20in%20the%20sense%20that%20it%20can%20grow%20as%20new%20rows%20get%20added)%3B%20or%20is%20it%20the%20result%20of%20one%20of%20the%20new%20Dynamic%20Array%20functions%2C%20FILTER%2C%20perhaps%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20initial%20assumption%20was%20that%20you're%20talking%20of%20the%20latter%2C%20and%20that%20could%20be%20tricky....so%20we%20may%20end%20up%20needing%20to%20look%20for%20a%20creative%20solution%20if%20this%20is%20something%20that%20you'll%20be%20needing%20to%20do%20repeatedly.%20But%20help%20us%20all%20get%20started%20by%20a%20little%20bit%20more%20expansive%20description%20of%20your%20situation%2C%20if%20not%20a%20copy%20of%20the%20actual%20spreadsheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1457612%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20dynamic%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1457612%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%20what%20I%20want%20and%20I%20cant%20perform%20is%20to%20place%20my%20results%20(value%20outside)%20inside%20of%20the%20pivot%20on%20the%20left.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hi
How to calculate, in the dynamic table itself, a column with the division of the results obtained in the table itself (example average/maximum)
2 Replies
Highlighted

@whnunes 

 

A little more description would be helpful. How exactly are you using the term "dynamic table," for example? Is it a standard Excel Table (which is dynamic in the sense that it can grow as new rows get added); or is it the result of one of the new Dynamic Array functions, FILTER, perhaps?

 

My initial assumption was that you're talking of the latter, and that could be tricky....so we may end up needing to look for a creative solution if this is something that you'll be needing to do repeatedly. But help us all get started by a little bit more expansive description of your situation, if not a copy of the actual spreadsheet.

Highlighted

@mathetes  what I want and I cant perform is to place my results (value outside) inside of the pivot on the left.