Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all.
I have a problem with a calculation of expressions.
In lines of expression I have calculated the sales of Year and PreviousYear.
If I show the year such size in column, is there a way to see both expressions in all the columns, like the following example?
2009 2010 2011
sales year sales2009 sales2010 sales2011
sales PreviousYear sales2008 sales2009 sales2010
thanks
Tiziana
hi tizia,
can you just explain your scenario little more detail?
whats are the two expressions?
Thanks
Hi Tiziana,
I think you mean to show in the table the result of the expression and the year, yes, this is possible, you can concatenate Text and expressions by using &:
=Year&': '&Num(Sum(Sales),'#,##0')