How to reduce my table report require 5 expression to 1 expression ?

[paulyeo11]

Hi All

I have a P&L Table , which can display correct figure i want. but if i need to display last 5 month data , i need 5 expression . May i know how to make it only using 1 expression ? and i just need to add YearMonth at Diamension ?

In my next posting i will enclosed my QV Doc.

Paul

[paulyeo11]

Enclosed my QV Doc

[Anonymous · Accepted solution]

Hi Paul,

I guess you're looking for this:

money(

sum({$<           year=,          month=,           MonthSeqNum = {"$(= '>=' & only(MonthSeqNum-4) & '<=' & only(MonthSeqNum))"} >}  Amount/$(ColumnDim98)/1000)

, $(vMoneyFormatK_GL))

[paulyeo11]

Hi Michael

Thank you very much. it work !

Paul

[paulyeo11]

Hi Michael 

May I ask . I notice that last week you reply post . And you send me file attachments.  The file name are all number. 

May I know the meaning of number ? As it is not date. Also not the track number....

Sent from Samsung Mobile

[Anonymous]

Paul, it's the ID number of the discussion, I take it from URL.