topic Above function with set analysis filter condition in App Development

Above function with set analysis filter condition

Manish — Sun, 05 Feb 2023 12:50:01 GMT

Hi All

I have a data set as below:

LOB	Number	Flag	Amount
A	1234	0	100
A	4567	1	150
A	7890	1	50
B	3344	1	200
B	6677	0	300
B	8899	1	400

First, I created a straight table with below dimension and expression.

Dimension: LOB, Number

Expression: Sum ({<Flag= {1} Amount)

LOB	Number	Flag	Amount
A	4567	1	150
A	7890	1	50
B	3344	1	200
B	8899	1	400

Now, my requirement is I need to write another expression as below but as soon as I am doing it, I am getting all the data in the straight table and not as per the above expression. Basically, the expression below should work only on the data which is filtered by the expression mentioned above.

Expression to be added: If (LOB <> Above (Total LOB),'1A','1B')

Re: Above function with set analysis filter condition

sidhiq91 — Sun, 05 Feb 2023 12:39:39 GMT

@Manish Could you please post what the expected output should look like?

Re: Above function with set analysis filter condition

Manish — Sun, 05 Feb 2023 12:49:23 GMT

@sidhiq91

As below:

LOB	Number	Flag	Amount	If (LOB <> Above (Total LOB),'1A','1B')
A	4567	1	150	1A
A	7890	1	50	1B
B	3344	1	200	1A
B	8899	1	400	1B