2 values with different dimension in one column

[petermoyaert]

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.

[avinashelite]

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

[swuehl]

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

The As-Of Table