3 Replies Latest reply: Apr 23, 2015 1:21 PM by Yeo Poh sai

# How to change my SET analysis to become accumulated ?

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

• ###### Re: How to change my SET analysis to become accumulated ?

enclosed my QV Doc

• ###### Re: How to change my SET analysis to become accumulated ?

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

• ###### Re: How to change my SET analysis to become accumulated ?

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