Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
it's possible to aggregate one subDimension in some cases ?
for example
i have
sales for products ; and products in categories
i want this dimensions
Category
+ProductName
+Others (in this case i want sumarize in one condition)
Expressions
Sum(sales)
Sum(quantity)
thanks
Ricardo
Which products should be included in 'Others' and which should be put separately?
Maybe try something like
=If( Match(ProductField, 'A','B','C'), ProductField, 'Other')
as calculated dimension.