Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a excel with 10 rows and 2 columns.
I would like create an indicator that is the sum of the B columns for those rows that have "x" as the value in column A.
Are you coming?
Hi Stefania,
Let say you have 2 Columns named ColA and ColB. Now you want to sum ColB which has ColA = X. Using set analysis, you can achieve this.
Sum({<ColA = {'X'}>}ColB)
Let me know if you need further explanation.
Regards,
Akshaya
it' s fine!!! Thank you so much!!!
Stefania
Hi Stefania,
You are welcome.
I would like to suggest to close this thread if you receive what you are looking for.
Regards,
Akshaya