Hierarchy wise Ranking in matrix

[Anonymous]

We want to calculate Three layer Hieranchy of Product,Sub Product and Category on basis of values. when we select Product it should show the sub Product under that particular product with ranking likewise if we select sub product it should show the category under that sub product.

Product	Sub Product	Category	Values
A	aa	C1	15
	bb	G1	10
B	cc	G2	20
	dd	C1	40
	aa	B1	15
C	hh	D2	30
	gg	G1	40

[amitchandak · Accepted solution]

@Anonymous , You need to switch rank using isinscope. refer

IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM

[Anonymous]

Thank You @amitchandak🙂