Using Set Analysis

[#1]

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

[brenner_martina]

Hi,

the right expression would be:

sum({$<RecordType={RecordType}>} Amount),

[#3]

Thanks, but it doesn't function. I have tried to put a specific value for RecordType:

sum({$<RecordType={'Def'}>})

In this way, that I don't want, I have the right sum.

[#4]

Hi,

the second solution is right, you just have to define a variable which will store "record type" and use it as a reference instead of "Def"

regard

christian

[#5]

Ok. I have created the variable varRecordType; when I select the RecordType I set this variable.

I have written sum( ${ RecordType = { $(=varRecordType) } } Amount), but it doesn't function.

[rbecher]

just try:

sum( ${ RecordType = {$(varRecordType) } } Amount) or sum( ${ RecordType = {"$(varRecordType)" } } Amount)

- Ralf

[#7]

None of these solutions function and there is a syntax error (where are the < and > characters?).

Is there a sure documentation about set analysis?

[rbecher]

Sorry:

<blockquote><pre>sum( {$ <RecordType = {$(varRecordType) }> } Amount) or sum( {$ <RecordType = {"$(varRecordType)" }> } Amount)

- Ralf

[#9]

Don't worry. I have already tried also these solutions without success!

Thanks

[#10]

Ok, I've solved with sum({$< RecordType = {$(varRecordType)} > } Amount).

The variable isn't set correctly.

Thanks