Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need a hand to set fixed riserimenti for a chart.
I have a billing year divided by 10 different programs, I would like to set up a graph in such a way that if I select only 5 programs, the total turnover in a given year does not change, so you can see the percentage of those five programs over the total turnover one year.
it's possible?
thank you
What is the expression that you are using right now?
UPDATE: try ignoring selection in Program field in the denominator expression
{<Program>}
I Haven't a denominator in expression connected to the program.
I calculate the annual revenue and i've a field on the db for the program.
I set two years in the graphic size and program and an expression like this (SUM(M_VALORE_RIGA))/M_FATT_CAMBIO, so when i selected a program it change the annual revenue.
I am guessing M_VALORE_RIGA is your Revenue field? May be this:
Sum({<Program>}M_VALORE_RIGA)/M_FATT_CAMBIO