straight table - multiple expressions - Feasibility check

[roisolberg]

Hi all,

ill try to simple it as much as i can
Background:
there are 4 objects
Master program --> Opportunity -> Potentials / Orders

1 Program can have many opportunities
1 opportunity can have many potentials/orders

Order is an actual order
potential is a feature order

I want to create the following table
so basically, 1 expression should contain 3 scenarios:

only for the orders i created 8 simple flags [2016-2023] (if the opportunity close year = Program won Year,1,0) and incremented Program won Year+1/+2....

than i used in the script and used the following expression

Sum({<OpportunityYear_Equals_ProgramFirstWonYear ={1}>}[Order.TotalAmount])
Sum({<OpportunityYear_Equals_ProgramFirstWonYear_Plus1 ={1}>}[Order.TotalAmount])
.
.
.

im pretty sure this is possible but im not sure what is the best way to approach this that will give me the desired ouput but also maintain preformance

assume all of the needed data is there (Dates or other fields to condition by)

Many thanks,
Roi

[roisolberg]

anyone?

[vinieme12]

Please post some sample data