Thank you for your response. I want to show a pivot table like this..
showing A1,B1,C1 values ex: actual,previous,target values by all products showing prod name top (by using scrollbar) for Metrics ex: sales,growth,share like dimensions. I cant do it by using different tables for each metric because i have many products to show by using scrollbar. If I scroll one table other wont scroll so It is not possible by dng this.
All are independent one having different expressions.
Pls help me to solve this problem..
Yeah i got the solution for above Problem by using ValueList we can create a temporary dimension having custom metrics.
I think the below link is helpfull