Set analysis with YTD and Alternate State, how to

[#1]

Hi,

I really need some help   😞

Objective:

To have a straight tabel with colomms who show values bases on different altenate states.

Current Expression

=SUM({<Year={'$(vMaxYear)'},Datum={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>}Sales)

How can I adjust the expression above to include a alternate state.

Alternate state 1 =  All data (lets call is alternate state "Everybody")

Alternate state 2 = Data selected Customer (lets call this alternate state "CustomerSelected")

Feedback would be appreciated!

Kind regards

[Anonymous]

I don't see a reason for alternate state here,

for the "Everybody" you can use

=SUM({<Year={'$(vMaxYear)'},Datum={'<=$(vMaxDate)'},Month=,Day=,MonthYear=,Customer=>}Sales)

for the "Customer Selected" the expression you provide, customer will be filtered based on your selection.

=SUM({<Year={'$(vMaxYear)'},Datum={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>}Sales)

[#3 · Accepted solution]

He Konstantins,

I believe you may have  "Everybody" and "Customer Selected" formulas "the other way around" but most important, you gave me the right directions. I solved my issue now and have a fine working straight table!

Thx

Arjen