How to add a grouped value field to the same field in script

[benvatvandata]

Hi,

To better explain my question, I will use an example:

Table: Events

Field: ItemCode     ;     Values: A, B, C, D

Field: Expenses     ;     Values: 1, 2, 3, 4

I would like to add 'ALL' as an ItemCode and the sum of A,B,C,D expenses as it's Expenses value.

So my result would be:

Field: ItemCode     ;     Values: A, B, C, D, ALL

Field: Expenses     ;     Values: 1, 2, 3, 4, 10

What would the script look like for this?

Thanks,

Ben

[benvatvandata]

take it easy... of course I appended it, I missed a quotation mark ha - but no expenses are shown?

[Gysbert_Wassenaar]

What field(s) are you using as dimension in your chart and what are the expressions you use?

[benvatvandata]

Dim1: Division

Dim2: ReportItemCode

Exp:

sum({<

MTGStatus = {'ASSIGNED','CLOSED','CLOSED BY FINANCE',

            'LOGISTICS CONFIRMED','PENDING/REP','PENDING/SPEAKER','PENDING/VENUE',

            'PROGRAM OCCURRED','RECONCILED', 'REQUESTED BY REP'},

            MTGDate = {">=$(=yearstart(today()))"}  >} Expenses)

Thanks,

Ben

[Anil_Babu_Samineni]

Your question is related to Script level. Have you seen Gysbert first reply

Or

This in bar chart?

[Gysbert_Wassenaar]

So, that same expression does return results if you use ItemCode as dimension, but not if you use ReportItemCode?

[benvatvandata]

Phew, sorry it took me so long to respond - creating a new field eventually worked with my model. Thanks gysbert!

-Ben