I need help for summing up diff field values for a single field

[ferha_jafri]

Hi everyone,

I need help as want to create a straight table with few field values showing as dimension and expression for Bud

for Total revenue=

((DD109+DD110+DD111+DD112+DD113+DD114+DD115+DD116+DD131+DD117+DD119+DD120

DD118+DD120+DD122+DD124+DD125+DD126+DD127)-(DD128))+(DD130+DD116+DD131+DD131

+DD134+DD174+DD173+DD137+DD138+DD139+DD175+DD141)

My issue is that when i am using these values they are also coming in the straight table as field values although i want to sum all these field values and dont want to show these field values under STR_DD_Desc FIELD i want to sum them up and show under Total revenue.And one more thing is how i can next field value suppose Revenue from operations under bud expression as for a new expression u will get a new column.Plz help i am attaching both the table view and my document.

Thanks in advance

Ferha Jafri

[Gysbert_Wassenaar]

I think you'll need to do something like in my example here. Or perhaps a more comprehensive and flexible solution like explained in this blog post.