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; } } }

Specify the columns for "grand total"?

ewb

Hi,
i'm new to birt and need help with the following problem:

Unsing the classicmodels sampledb i have created a crosstab with products as columns and customers as rows. I summarize the data "Quantityordered".

Now i want to add a column that sums the Quantityordered of the columns with productcode **** and productcode yyy only.
A "grand total" allways sums all columns. Can i specify the columns for "grand total" or is there another solution for this?

Find more posts tagged with

Comments

ewb

Hi,
i've found the (simple) solution.
I can specify the columns using the filter condition.
Although only my defined Summary Fields are "clickable" in the Expression Builder a condition like
dimension["Product"]["PRODUCTCODE"]=="S10_1949" || dimension["Product"]["PRODUCTCODE"]=="S10_4757"...
works fine.

mwilliams

Hi ewb,

Glad to hear you found a solution. Let us know whwnever you have questions.