variable with parameters

[tgumbing]

Hi,

I have a variable with 2 parameters :

FuncCal=SUM({<Year={$1}, Month={$2} >}  TimesValue)

And when I call it in my Pivot Table it's not working :

=$(FuncCal(max(YearSelect),max(MonthSelect)))

Can some one help me ?

Thanks

[sunny_talwar · Accepted solution]

May be change the variable to this

FuncCal=SUM({<Year={"$(=$1)"}, Month={"$(=$2)"}>}  TimesValue)

[tgumbing]

Thanks