Dimension total

[srinivas1921]

Hi,

as per attached image ,I have two dimensions(Product,Units) and two facts(revenue,cost) in a Straight table.

I want to see totals for units(dimension) on the top of this column.

kindly provide me expression for total of dimension(units) on top of this column

[#2]

I agree with maxgro - since you are counting units over product, units does not need to be a dimesnion and the qvw Krishna sent to show totals should provide you with the solution to your issue - if it does not please let us know

[krishna_2644]

See attached and follow as is.

Thanks

[maxgro]

Is there a reason to have units as dimension and not as measure (and use the expression total to get the total as in your image)?

[krishna_2644]

Any Luck?