Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
See attached and follow as is.
Thanks
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)?
Any Luck?