Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to visualize the following
Dimension is month
jan/2016 feb/2016 mar/2016
Sales
Budget
Sales LY
Variance
Anyone a suggestion with regards to sales LY : so in the column of eg. jan/2016 I would like to visualize as well sales of LY and the variance against sales of jan/2016.
add Month and in the expression add>sum(Sales LY ) and sum(Variance)if Sales LY and Variance is a column
Could you please share the data so that it will be helpful for us to suggest the solution
Create an AsOf Table, then you can use something like
Sum({<MonthDiff={12} >} Sales)
for previous year sales.
Variance:
=Sum({<MonthDiff={0} >} Sales) / Sum({<MonthDiff={12} >} Sales) -1