Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, try this...
sum({<VOUCHER_ID={'LIV'}, YEAR= ,MONTH= >}BAL_QTY)
Sum({$<VOUCHER_ID={'LIV'}, month = ,year=>}BAL_QTY)
You can take these as two seperate expressions.