Set analysis and selection on the same field

[micheledenardi]

Good evening everyone,

using the following set analysis expression i'm retriving the sum of report hours for request 69,70,71....268.

But i select one request number, for ex 71, the table does not reflect the selections and continue to show the sum() al all request number of the set analysis.... how to fix ?

Sum({$<[Request Number]={69,70,71,72,73,74,75,76,176,197,255,264,268}>} [Report Hours])

[Aurelien_Martinez]

Hi,

You can create a new field like [Request Type] and use it in set analysis.

for example:

MyTable:

LOAD *

INLINE [

Request Number, type

69, a

70, a

71, b

72, b

];

Sum({$<type={'A'}>} [Request Hours])

Aurélien

[marcus_sommer · Accepted solution]

Try it with:

Sum({$<[Request Number]*={69,70,71,72,73,74,75,76,176,197,255,264,268}>} [Report Hours])

- Marcus