According to information provided by you, I think you want to display expression different and separate for different dimensions.
But the values of any expression for two dimensions in a row will be always same, if the dimensions are linked by some way.
Taking your data as example.
Dimension1 and 1 are two dimension values in a row. And any expression will give same result corresponding to any of these two dimensions.
If, your issue is something different from this, kindly attach your application for better understanding.
hi Timanshu :
Yes you are absolutely correct, this is what I am looking for.
Apart from this requirement I am also not sure if this kind of chart form is possible in Straight table or Pivot table.I am majorly confused with Designing of this chart. Please suggest
Can you attach an example to show Data?
As an example, I have a dimension naming States and a dimension naming Cities and I have an expression to show sum of sales.
States Cities Sum(Sales)
Haryana Gurgaon 7000
Haryana Sonepat 5000
Maharashtra Mumbai 6000
Maharashtra Pune 3000
Now, Always Sum of sales will be calculated on City. As City is subset of state.
Do you want like this :
States Cities Sum(Sales) by City Sum(Sales) by state
Haryana Gurgaon 7000 12000
Haryana Sonepat 5000 12000
Maharashtra Mumbai 6000 9000
Maharashtra Pune 3000 9000