Set analysis

[#1]

I have some table boxes. All of which I only want to display the current months totals.

Meaning where COMMAG.MONTH is equal to the current month. I only want the written premium, adjusted premium, etc. to display for that month.

[daveamz]

Hi,

First, create a variable like vDate=date(today(),'YYYYMM')

then, for written premium, ajusted premium etc. use the following expression:

sum({<COMMAG.MONTH={"$(vDate)"}>} written premium value)

Regards,

David

[chematos]

daveamz01 is right

In order to ignore other filters you could add TOTAL to the expression

sum({<COMMAG.MONTH={"$(vDate)"}>}TOTAL written premium value)

Regards

[#4 · Accepted solution]

Thanks guys. I ended up doing it a different way.

=

if(COMMAG.Process_Month=month(today(1)),if(COMMAG.Process_Year=year(today(1)),COMMAG.Process_Month

))

As a calculated dimension. I then supressed nulls for the dimension and hid the calculation on the presentation tab.