Item order within its area

pan.jpg

Hello everybody! o/

I'm trying to figure out a way to create a column with the value of the item considering its "area" (the image can explain what this 'area' means for), from a pivot table, in this format:


The column; What it REALLY means (the order)
1.1.1 - 1st area; 1st state of 1st area; 1st unitsSold of 1st state of 1st area
1.1.2 - 1st area; 1st state of 1st area; 2nd unitsSold of 1st state of 1st area
1.2.1 - 1st area; 2nd state of 1st area; 1st unitsSold of 2nd state of 1st area
1.3.1 - 1st area; 3rd state of 1st area; 1st unitsSold of 3rd state of 1st area
1.3.2 - 1st area; 3rd state of 1st area; 2nd unitsSold of 3rd state of 1st area
1.3.3 - 1st area; 3rd state of 1st area; 3rd unitsSold of 3rd state of 1st area
1.3.4 - 1st area; 3rd state of 1st area; 4th unitsSold of 3rd state of 1st area
2.1.1 - 2nd area; 1st state of 2nd area; 1st unitsSold of 1st state of 2nd area
2.2.1 - 2nd area; 2nd state of 2nd area; 1st unitsSold of 2nd state of 2nd area
2.2.2 - 2nd area; 2nd state of 2nd area; 2nd unitsSold of 2nd state of 2nd area
3.1.1 - 3rd area; 1st state of 3rd area; 1st unitsSold of 1st state of 3rd area
3.1.2 - 3rd area; 1st state of 3rd area; 2nd unitsSold of 1st state of 3rd area
3.2.1 - 3rd area; 2nd state of 3rd area; 1st unitsSold of 2nd state of 3rd area


Some of you have already stuck with something like this?

I have already tried a lot o COUNTIF like, but none of them solved; some got really close!


Tks!