Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Adding multiple Percentile columns to each Table in a Table of Tables

Hi Jimmy801 , This is with respect to my last post, on `Table of Tables`. I am trying to find an easier & concise way to do all the Percentile calculations and column additions in each table in the ...
Need Help
Show and Tell
Tips and Tricks
Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
5 years ago

Hello Anonymous 

 

I cannot confirm that. When I unload it and load it, then the correct data is shown in a new sheet

Then there is something else causing this

 

BR Jimmy

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Now i got 2 extra columns viz., Column1 & Column2 added when i loaded to a new sheet in Column C and 5 extra columns when i loaded to a new sheet in Column F. I think i know what is happening. When i add a new sheet and select the column & row i.e cell where the data should be loaded, it somehow offsets those many columns from the table start column.

If i just load it by selecting New worksheet in the load dialog, it will default to the 1st column only and so no extra column gets added.

 

See, if you are aware of this same behaviour in your excel and if you know whats causing this issue.