topic Re: Are there ways to have different, overlapping groups of columns? in Discussions

Are there ways to have different, overlapping groups of columns?

ehchandlerjr — Sat, 17 Feb 2024 15:11:59 GMT

Hello - Are there ways to have multiple overlapping groups of columns? Right now, the best I can come up with is a script at the top right to select predefined columns, which is servicable until you have a bunch of scripts in addition to your grouping scripts, so if there's another way to do this, it would be nice.

Thanks!

Re: Are there ways to have different, overlapping groups of columns?

jthi — Sat, 17 Feb 2024 16:01:47 GMT

If you want to have single column in multiple groups (or rather change the groupings) you would have to do it by scripting. I would most likely create some sort of an add-in which would let be define the groups, change the groups, possibly save them to a file for easy loading/table variable and add those group "swaps" to table scripts for easy usage.

This might give some ideas

Re: Are there ways to have different, overlapping groups of columns?

txnelson — Sat, 17 Feb 2024 18:01:30 GMT

One way to handle this is by creating new formula columns who's formula simply points to the original column. The new formula column can then be put into a new group.