Sum on different period

[nboccassini]

Hi all,

I have a dataset like this (for more countries /cities):

COUNTRY	CITY	PERIOD	VALUE
ITALY	ROME	H1-2017	1
ITALY	ROME	H2-2017	2
ITALY	MILAN	Q1-2017	3
ITALY	MILAN	Q2-2017	4
ITALY	ROME	H1-2018	5
ITALY	ROME	H2-2018	6
ITALY	MILAN	H1-2018	7
ITALY	MILAN	H2-2018	8
....	..	..	..

In a pivot like this:

COUNTRY

INDEX

PERIOD

I need to calculate  per each COUNTRIES

INDEX: SUM OF

 - ALL VALUE FOR ALL PERIODS LIKE 'Q*'.

- ALL H1-2017 VALUES FOR PERIOD H1-2018 and H2-2018

- ALL H1-2017 VALUES FOR H2-2017

and more

I've make a mapping table:

Q1-2017 --> Q1-2017

Q2-2017 --> Q2-2017

H1-2017 --> H1-2018

H1-2017 --> H2-2018

....

...

I can't use a IF solution, How make a formula like this?