Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies