Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i have a table-
because of the set analysis in column(6) i see in the table all the product types (first column) .
i want to see only the type with the full data (if i removing the set analysis in the 6 expression its show only the products type i want)
hope im clear...
add an additional sum before your aggr, sum(aggr(sum...)
Please write your set analysis and explain your needed conditions
Please write your set expression to have look at
no, you are not clear
Can you be more specific in your requirements?
my table with the set analysis expression-
my table without the set analysis expression-
the set analysis expression make the table to include all the values of the dimension.
i want the date of the table with the set analysis expression but to see only part of the values of the dimension
(like in the second table)
its hard for me to explain...
can someone help?
include your expression into a aggr() function
aggr(sum{set analysis} measure), dim1, dim2)
where dim1 and dim2 are the dimension (in that order) of your table
Fabrice
tnx,
its working.
but is there a way to see the partial sum (totals?)...
add an additional sum before your aggr, sum(aggr(sum...)