Set analysis Expression for a single item

[Anonymous]

In a pivot table having item codes, and sum of item cost (with some calculations and conditions), I want to have separate calculation for just one item. How do I do that in the fronted using set analysis?

Eg.

Header 1	Header 2
10001	4567
10002	232131
10003	32233
10004
10005	3486

Here I want 10004 to be calculated as  10002/10001 (Division) i.e. (232131/4567). How do I do?

TIA

[robert_mika]

What's the logic behind that?

What if you had two gaps?

[MayilVahanan]

Hi

Try using if condition something like this

=If([Header 1] = 10004, Above([Header 2],2)/Above([Header 2],3), Sum([Header 2]))

[Anonymous]

Which two gaps?

[Anonymous]

Thank you Mayil. But this is just an example. the real data has dynamic labels, alternate states and many rows. so unable to implement it.

[Anonymous]

It is a P&L report where a particular code is a division result of two codes.

[robert_mika]

You gave example with one gap.

What if you have more than one gap or gaps with two or more rows

[SunilChauhan]

simply use below funtion

below(Header2)/Header2

or

below(sum(Header2))/sum(Header2)

hope this helps

[tresesco]

Have a look here: New value as quotient of other two value