Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have SET analysis as beow working fine :-
sum({$< year=, month=, MonthSeqNum = {$(=only(MonthSeqNum)-12),$(=only(MonthSeqNum))} >} sales/1000)
When i click month = 1 the amt display 546
When i click month = 2 the amt display 826
May i know how to modify the above expression , so that it will behave as below :-
When i click month = 1 the amt display 546
when i click on month = 2 so it display as 546 + 826 = 1372 ?
Paul
This couldn't be achieved with the set analysis expression itself you need the above/below functions to accumulate the expression with the other rows, see: Re: Rangesum Above not working.
- Marcus
enclosed my QV Doc
This couldn't be achieved with the set analysis expression itself you need the above/below functions to accumulate the expression with the other rows, see: Re: Rangesum Above not working.
- Marcus
Hi Sir
Thank you for your suggestion , and i manage to recall the expression which some one help me 3 year ago :- .
Diamension Year and ColumnDim
money(
Sum({<IsInYTD={1}, Year={">$(=year(today())-2)"}> } sales/$(Columndim89)/1000)
, $(vMoneyFormatK))
money(
Sum(
{<Year={'>$(=year(today())-2)'}>}
sales/$(Columndim89)/1000)
, $(vMoneyFormatK))
Diamension on yearmonth:-
sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} sales/$(Columndim89)/1000)
Thank you.
Paul