0 Replies Latest reply: Apr 10, 2012 2:12 AM by Ashwini Swadi RSS

    How to use the Total of one expression in another expression in straight table

      Hi ,

      I have straight table with  3 expression, Eg : Customer Utilized, Customer Non Utilized and Utilization. Now the third expression Utilization is derived from Customer Utilized for each dimension called Resource. The utilization calculated is correct for each resource but when i want to calculate the total utilization i need the values of the total Customer Utilized which is got by the sum of rows in the total mode of Customer Utilized expression. How do i pull this total value from this expression and use it to calculate the total utilization. I do not want ot use macro due to some industry standards.

       

      Can anyone suggest me solution?

       

      Regards

      Ashwini