4 Replies Latest reply: Nov 16, 2016 4:49 AM by Sunny Talwar RSS

    calculation issue

    Joey Spoor

      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 ?