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

Adding independant column to a crosstab table

dinadonna238

Hi Guys,
 
How can I add independant column to a crosstab table that represents total number of remittances per country as in attachment
 
My Regards

Find more posts tagged with

Comments

micajblock

Isn't that what is in the left column? What do you mean independent? What does the data look like? Do you have an example using a CSV file?

dinadonna238

Thanks for your reply.
Yes the left column named "total no of remittances"
 
My Regards

micajblock

Will adding totals work?

dinadonna238

Yes it works perfect ! but what if I want to add another average column besides grand total that calculates average sales through 12 months of the year per each country as in attached sample .
appreciate your support
 
My Regards

micajblock

Try dragging in an aggregation.

dinadonna238

could you please give more clarification 
I tried to drag and drop another salesAmount measure field temprorily ( inorder just to create another grandTotal2 column ) then change it's label into " Average" and replace it's cell with cell data from data binding column named average I have created but I found a problem when trying to delete the temprory salesAmount measure field as it's dependant to the average column and will be deleted as well
I tried also to create 2 crosstabs in a grid the main crosstab as in attached sample except the average and another one with average for each country but I faced that 2 crosstab tables are not well aligned and also i think this is not good solution
 
My Regards
 
Dina

micajblock

What version of BIRT are you using?

dinadonna238

I'm using birt designer 4.5 v2 integrated with eclipse Mars

micajblock

see attached

dinadonna238

that's perfect thanks a lot