Hi,
I was wondering if there is any way to not display a column of a table if the total for that column is zero? For example, if I had the following table:
Col1 Col2 Col3 Col4
Row1 1 0 2 3
Row2 2 0 4 2
Row3 1 0 2 1
Total 4 0 8 6
should show up as
Col1 Col3 Col4
Row1 1 2 3
Row2 2 4 2
Row3 1 2 1
Total 4 8 6
with column2 being removed entirely.
If I cant figure out a way to do this the resulting tables are going to be entirely too large and unwieldy-looking.
Thanks in advance for your help,
Sheryll
Sheryll
I was wondering if there is any way to not display a column of a table if the total for that column is zero? For example, if I had the following table:
Col1 Col2 Col3 Col4
Row1 1 0 2 3
Row2 2 0 4 2
Row3 1 0 2 1
Total 4 0 8 6
should show up as
Col1 Col3 Col4
Row1 1 2 3
Row2 2 4 2
Row3 1 2 1
Total 4 8 6
with column2 being removed entirely.
If I cant figure out a way to do this the resulting tables are going to be entirely too large and unwieldy-looking.
Thanks in advance for your help,
Sheryll
Sheryll