Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Buenas tardes / Good afternoon
Hola, tengo una tabla simple cuyos valores de dimension son una lista de valores:
=ValueList('1 VENTA TOTAL','2 DEVOLUCION','VENTA NETA COMERCIAL','3 RECUPERACION','4 BONIFICACION',.....
Y despues las expresiones estan caluladas por "Pick"
Pick(
Match(ValueList('1 VENTA TOTAL','2 DEVOLUCION','VENTA NETA COMERCIAL',
//VENTA TOTAL
Sum({$<AÑO={"Real-2011"}>}[1 VENTA TOTAL]),
//DEVOLUCION
Sum({$<AÑO={"Real-2011"}>}[2 DEVOLUCION]),
//VENTA NETA COMERCIAL
Sum({$<AÑO={"Real-2011"}>}[3 VENTA NETA COMERCIAL]),
....
De estos rubros tengo datos del 2012 y comparo contra el 2011 y contra un Presupuesto, y quisiera colocar algun color a dichas sumas dependiendo si estan por encima o por debajo del presupuesto o el 2011, en excel esto seria facil con un formato condicional. ¿Como puedo lograr esto en el codigo?.
Gracias.
Saludos.
--------------------------------------------------------------------------------------------
Hi, I have a simple table with a valuelist as dimensions field
--- See first code---
And after that, the expresions are calculated by a "Pick" sentence
--- See second code--
I have 2012 data and evaluate this fields against 2011 and a budget, and i wanto to put some color according theyr performance against 2011 or the budget, in excel a simple conditiona format would solve this issue. ¿How I could solve this in the code?
Thanks
You can write an expression to format however you'd like under Chart Properties > Expressions > Click on plus sign:
Hi, thx for the fast answer.
The issue by doing it that way its that I have diferent chriteria for each value, let me set a small example:
Field | Real 2012 | Budget | 2012 vs Budget
Sales | $ 900 | $1,000 | 111% (Green, we sell more than spected)
Costs | $ 500 | $ 600 | 120% (Red, it cost more than spected)
In the first case, beeing above 100% goes green, but in the second case goes red.
Hope this helps to clarify
Thanks
HI
try like this
=if(sum(sales)/sum(total sales) > 100%, green(),red()) in background color//
in this,instead of the above expression, use yours..
Hope it helps.. or post a sample file
Here is a sample file of using colors based on an expression.
Hi, thank you both for the answers, I finally solved out, with a little of both, I ended copying the way I calculate the expression and adding there the conditions for colors the way I needed
Thank you again