in a document I have a pivot chart with Year and Month as dimensions and an Amount as an expression. In a list box I have joined year with month and with recordtype. I don't want to use recordtype with a dimension but I could have temporary and definitive records. When I select the recordtype I want to calculate the sum of the amount with the selected recordtype and for year and month measure.
I have tried to use this expression, unsuccessfully: sum({$<RecordType>} Amount), but I have the sum respect of year and month dimension but not for the selected RecordType.
if I got you right, you do want to respect the selected RecordTypes in your chart with dim1= Year and and dim2=Month. And you are using a listbox with a concatenated string with "Year + Month + RecoredType". So just for fun:
