Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody.
I have a next situation:
Dimension = if(left(cuenta,1) ='1','ventas a','ventas b')
expresion 1 = sum({$<mes={201011}>})
expresion 2 = sum({$<mes={201012}>})
The report show for example
expresion1 expresion2
ventas a 100 120
ventas b 80 71
total 180 191
How i generate a new expresion 3 in order to show the percentage of 100 under 180 y 80 under 180 for each row ??
Thanks in advance
expresion 3
ventas a 100/180
ventas b 80/180
Hi,
Check with TOTAL keyword
Expression as sum({$<mes={201011}>})/sum(TOTAL {$<mes={201011}>})
Celambarasan
Hi,
Check with TOTAL keyword
Expression as sum({$<mes={201011}>})/sum(TOTAL {$<mes={201011}>})
Celambarasan