Sum of 12 months irrespective of selection

[Anonymous]

HI,

I have a database that contains information of several years in a monthly basis, latest is Jan 2017 for Sales and full year for Budget 2017, in a text object I am trying to show the full year value of whatever year budget, but when I select one month or more months i got the value of that specific month or if I select more months then I got the sum of those periods.

What I would like to achieve is to get the full year budget irrespective of the selection of a particular year.

Please

[Gysbert_Wassenaar · Accepted solution]

You can use set analysis expressions to ignore certain selections. Suppose you have a year field called Year and a month field called Month. And you have an expression sum(Amount). To make the expression ignore selections in the Month field you change it to sum({<Month=>}Amount). See A Primer on Set Analysis for more information.

[Anonymous]

Thank Gysbert, it worked

Cheers