Set Analysis without Aggregation in TextBox

[psk180590]

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!!

[sunny_talwar · Accepted solution]

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)

[vijetas42]

do you want to show difference between values for year 2018 and 2017 for each product in text box?

[shiveshsingh]

Do you mean to get the desired results without SUM( Aggr func)? It's not possible i guess.

[psk180590]

I used Only to get my desired result

[psk180590]

Thanks all.