Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a data table in below format
Year | Product | Value |
---|---|---|
2017 | N1 | 52.80 |
2018 | N1 | 56.93 |
2017 | N2 | 30.98 |
2018 | N2 | 25.18 |
From the above table i'm looking to have two text boxes for each Product showing the differnce in Value versus Last year.
Text Box 1: 4.13
Text Box 2: -5.80
If i use the Sum in Set Analysis it gives me a completely wrong value. Please, help me in getting this without any AGgregation function.
TIA!!
How can you use set analysis without using any Aggregation? You will need to use Sum, Avg, Only to use set analysis... try this
Test Box 1
Sum({<Year = {'2018'}, Product = {'N1'}>}Value) - Sum({<Year = {'2017'}, Product = {'N1'}>}Value)
Test Box 2
Sum({<Year = {'2018'}, Product = {'N2'}>}Value) - Sum({<Year = {'2017'}, Product = {'N2'}>}Value)
How can you use set analysis without using any Aggregation? You will need to use Sum, Avg, Only to use set analysis... try this
Test Box 1
Sum({<Year = {'2018'}, Product = {'N1'}>}Value) - Sum({<Year = {'2017'}, Product = {'N1'}>}Value)
Test Box 2
Sum({<Year = {'2018'}, Product = {'N2'}>}Value) - Sum({<Year = {'2017'}, Product = {'N2'}>}Value)
do you want to show difference between values for year 2018 and 2017 for each product in text box?
Do you mean to get the desired results without SUM( Aggr func)? It's not possible i guess.
I used Only to get my desired result
Thanks all.