nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Aggregation on visible columns

ajunuthula

Hi everyone,

Is there a way to use the aggregation on only visible columns?

Thank you,
Aparna

Find more posts tagged with

Comments

mwilliams

Hi Aparna,

Is this in a crosstab or a table? Can you explain a little more about the scenario? Thanks.

ajunuthula

Hi,

This is a table, have 5 columns and the 6th column holds the sum for each row.
For eg, when the 3rd column is not visible, I need the sum for the 1,2,4,5 columns only to be displayed.

Please let me know if you understood right.

Thank you,
Aparna J

mwilliams

Aparna,

In your expression for the total, you should be able to do the same check that you did to hide a certain column and subract that column's value from the total, I would think.

ajunuthula

Hi,

Its solved now

. I used the if condition in the equation, checked if the column is not visible and added the rest of the columns.

Thank you,
Aparna

mwilliams

Not a problem! Always glad to help!