calculation issue

[jsnova]

I have the following results  (pivot table)
                              State A                         State B
Company A          avg(DurationDays)
         

--
                              State A                         State B
Company A               5                                   4
Compnay B               3                                  12

Now they want to get  a horizontal summary may be in seperate table

They Want Company A 9 days
                    Company B 15 days

tried things like aggr(avg(DurationDays),StateDescription) with the dimension company, but then i get null values

how to fix this ?

[Gysbert_Wassenaar]

What do you want to do? Sum the averages or average the averages or something else?

If you want the sum of averages try something like this: Sum(aggr(avg(DurationDays),CompanyNameDimensionHere,StateDescription))

[sushil353]

Hi,

If you are using a straight table then try :

sum(aggr(avg(DurationDays),Company))

[#4]

Can you plz elaborate little more

[sunny_talwar · Accepted solution]

Use Company as dimension

Expression

Sum(Aggr(Avg(DurationDays), Company, State))