How to calculate months value in set analysis

[varma8998]

Hi All,

I have table like in the below format

Month         Region

July           Canada

August        New York

September  Canada

October       Australia  

November   Australia

December   India

i want to show the each and every month separately using set analysis

[Taoufiq_Zarra]

what is the expected output ?

[varma8998]

Hi

I know how to calculate the max month and min month values by using the set analysis

how to calculate between months

[martinpohl]

for example:

create a chart,

month as dimension

sum({<datefield={">=$(=addmonths(monthstart(max(datefield)),-6)<=$(=monthend(max(datefield))"}, Year, Month, Monthname>} Value)

to see values from 12/01/2019 to 6/5/2020

Regards

[varma8998]

How to see the value june August September out of 12 months