help in set analysis

[ali_hijazi]

Dears

got a pivot table

that shows number of defects that are pre-release or post release

check attachment to understand what I'm going to ask

for v3.1.28 I have 53 prelease defects and 3 post release defects

each release v3.1.28 will have another column called release_phase that will be v3.1.28-PR if the defects dates are created after release dates and so on

for a given release x i want to sum all pre release plus those that are post release and for x-PR I want to sum only those that are post release

please help me with the third expression

check attachement and advise

for version v3.1.28 the third column should give 3 whereas when I select v3.1.29 with .28 it gives 7 (3+4) 3 for .28 and 4 for .29

[maleksafa]

here you go, you should use the aggr function and not the TOTAL function.

[ali_hijazi]

scroll down to the table and see that i gives null in the cells beneath

[ali_hijazi]

this is not correct Malek

[maleksafa · Accepted solution]

check now, for some dimensions the aggr is returning more than one value, that is why it is empty.