11 Replies Latest reply: Apr 27, 2011 12:00 PM by pscorca69 RSS

    Using Set Analysis

      Hi,

      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.

      Any suggests to me, please?

      Thanks