i want to exclude all dimension from calander selection

[#1]

Hi,

i have multiple dimension columns and want to ignore all dimension from calender selection ie

sample data

Dimension1 Dimension2  Dimension3              Dimension4     expression

MainBranch  SubBranch   BranchOpeningDate  BranchStatus   sum(salesamount)

ABC                 A1                    '01/01/2010'          CLOSED                     0

ABC                 B1                    '13/05/2011'          ACTIVE                       10000

ABC                 C1                    '01/08/2009'          ACTIVE                       20000

CDE                D1                    '05/02/2012'           CLOSED                    14000

FEG                E1                     '30/11/2013'          ACTIVE                        50000

Now i want all dimension values should be exclude from any selection of calender like month/year/date and expression value should be change through any selection.

kindly help me to resolve it

[its_anandrjs]

Write like a set analysis stmt

sum({ <month=,year=>,date=  >} salesamount)

some change in script
Hope this helps

[linusblomberg]

Exactly. A good idea is to keep a no dates variable in case you want to add a week or quarter dimension at a later stage

vNoDateVariables: month=,year=,date=

and in your expression you type

sum({$<$(vNoDateVariables)>} salesamount)

[its_anandrjs]

Above solution for if you exclude month/year/date from expression

Thanks & Regards