merging to expresion

[#1]

AOA

I have a table in which i m showing sum of bal_qty for only thos voucher having value LIV

sum({<VOUCHER_ID={'LIV'}>}BAL_QTY)

Now I also want that selection of year and month dimension doesnot effect on this table.

sum({<YEAR,MONTH=>}BAL_QTY)

NOW this two exprsion are working fine individualy how to combine them on single expresion to get desired out put

which is

(sum of bal_qty where vouvher_id='LIV' and free from year and month selection)

regards

[christian77 · Accepted solution]

Hi, try this...

sum({<VOUCHER_ID={'LIV'}, YEAR= ,MONTH= >}BAL_QTY)

[er_mohit]

Sum({$<VOUCHER_ID={'LIV'}, month = ,year=>}BAL_QTY)

[sujeetsingh]

You can take these as two seperate expressions.