Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression with 2 dimensions. I want the expression to cut by one of the dimensions but not the other. I know with set analysis we can have it not filter by selections but is there a way to say don't cut by an expression?
I think you need the total qualifier with field list here, like using Customer and Product as dimensions and
=sum(total<Product> Value)
as expression will return the sum of Value per Product, so not regarding the Customer dimension.