Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
We have a report where there is a need to add a measure that will always calculate difference between the columns before it. Similar to below table
Actual | Budget | Var | |
Measure1 | 10 | 4 | 6 |
Measure2 | 5 | 5 | 0 |
Measure3 | 6 | 4 | 2 |
This could be done using Column(1) - Column(2) in theory.
However if you notice here i have a Dimension that has {'Actual', 'Budget'} and i have three separate Measures, so Column(1) - Column(2) will only give me difference between the measures for the same value of the Dimension.
Is there a way to do this in Sense ?
Hi,
You can use valuelist to create custom columns.
Dimension:
=ValueList('Actaul','Budget','Var')
Measure:
Pick(Match(ValueList('Actual','Budget','Var'),'Actual','Budget','Var'),
Sum({<TYPE={'Actual'}>}VALUE),
Sum({<TYPE={'Budget'}>}VALUE),
Sum({<TYPE={'Budget'}>}VALUE)-Sum({<TYPE={'Actual'}>}VALUE)
)
Hope it helps.
hi thanks for the post
This helps to a certain point but still facing some issues:
Ideally, if there is a way to do as was present in QLikView, where you can just reference the Column named Actual & Budget and get difference between them.