Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I have a problem with total aggregation in dimension.Please check the attached and let help me to find the solution.
I want the total of Nb. Cust at.
Thanks
Example attached.
Maybe removing the year from the aggregation?
Not sure if I understand, you want which column to be aggregated as Total?
As far as I see, Nb. Cust is a dimension, you usually don't aggregate dimension values, but expression values.
Thanks for replying,
I want to see the total of the aggregation (dimension ) it means total of (Nb.cust) as a partial total.
Is there any way to achive it.
Thanks
I dont know if i understand you correct, but if you move the calculated dimension to the left, and just add a partial sum, will that solve your problem?
Thanks Marcus,
We want to see a number for each row and the total( or the partial total) at the end.
If you have any idea, I appreciate.
Thanks,
Nima
If you use something like sum(NB_CUST) as expression, you get your totals, but I assume that is not what you want, you want only one expression evaluation per line, not per Year?
So, as stefan said is not a dimension but an expression.
Move it to the expression tab and I believe you dont need to do the aggregation.
Nima,
are u asking wath i post there some time ago?
Look my post
Not exactly what you did, because I don't want to repeat it for every year.
Thanks