Hi,
I've defined a matrix in a report which looks like this:
group by column group by column
Description Data Data
Description Data Data
Now I'd like to add a colum which sums up the Data:
group by column group by column Total
Description Data1 Data2
sum(Data1+Data2)
Description Data3 Data4
sum(Data1+Data2)
The only thing which I found is to add subtotals but this only counts
my first group by column. How can I add a total column?
ThanksOk. I just found out I have to add an aggregate function to my data
fields (in this case summ) and now it works).
Thanks
florian schrieb:
> Hi,
> I've defined a matrix in a report which looks like this:
> group by column group by column
> Description Data Data
> Description Data Data
> Now I'd like to add a colum which sums up the Data:
> group by column group by column Total
> Description Data1 Data2
> sum(Data1+Data2)
> Description Data3 Data4
> sum(Data1+Data2)
> The only thing which I found is to add subtotals but this only counts
> my first group by column. How can I add a total column?
> Thanks
No comments:
Post a Comment