Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make my Table 2 Can display Sept till Dec Revenue amoune ?

Hi All

Table 1 Expression Can display Jan till Nov Revenue :-
(Sum({<rEVENUE={rEVENUE}>}Amount))

Table 2 Expression Can only display Jan till Aug Revenue :-
Money(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1, $(ColumnDim108)))
,
$(vMoneyFormatK))

Above expression is working fine previouly, Suddenly it cannot work.
Notice that Table 1 and Table 2 expression label display as "Jan till Aug 2019 rEVENUE"
How to make it display as "Jan till Nov 2019 rEVENUE"

Hope some one can advise me.

Paul

 

1 Reply
paulyeo11
Master
Master
Author

Hi All

Enclosed my QVW

Paul