Show a Text as Expression

[marqupcmb]

I'm have created a PivotTable with 3 dimensions and 2 expressions that sum the Actual and the Budget amount of the MaxMonth of Actuals it means last month closed.

----Budget Sum for max month with actuals 
=sum({<Chart={'Actual'}, Status={'BU 2017'}, Month={'$(vMaxMonthA)'}, Year={'$(vMaxYear)'}>}Amount)

And I have a file with the remarks or comments of each month for the delta but I can't make it show the corresponding remarks without selecting the month. I don't want to do that because I have to Pivots this wich should show  the reamarks with the same condition as the sum, is there any way?

Last Closed Month      

P&L	Name	Type	Actual	BU	Δ	Remarks
Revenue	Name 1	Name 1 a	100	110	-10	aaaaa
Revenue	Name 1	Name 1 b	300	280	20	bbbbb
Revenue	Name 1	Name 1 c
Revenue	Name 2	Name 2
Revenue	Name 3	Name 3 a

FYP

P&L

Name

Type

2017

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Total

Revenue

Name 1

Name 1 a

Chart

Actual

Actual

Actual

Budget

Budget

Budget

Budget

Budget

Budget

Budget

Budget

Budget

Revenue

Name 1

Name 1 b

Revenue

Name 1

Name 1 c

Revenue

Name 2

Name 2

Revenue

Name 3

Name 3 a

[marcus_sommer]

Try something like: only(Remarks) or maybe concat(Remarks, ' + ')

- Marcus

[marqupcmb · Accepted solution]

I did that but showed Remarks when it only exist in one month, I finally added a dimension as

=if(Month='$(vMaxMonthA)',Month)

and  the expression Remarks

and now it shows the last month closed and if i pick a previous month the remarks of that month.