Alternate state need to apply for a button

[Swathi]

i have created button to show comparison growth of 2022 vs 2023 values in the button label.i have period filter fot the sheet, and default state period is R12M for that sheet. But in the Button iam  showing comparison growth of 2022 vs 2023 values in the button label.. to get for the button period should be Month-Year. i tried to applly alternate state but it is not working. Kindly help me to resolve the issue.  for overall sheet default state should R12M, for that buttons it should be month year to get ouput .

Button label expression =if(vasp =1 ,$(vba1),
if(vasp =2 ,NUM($(vba1)/$(Vcount),'#,##0.0%'),
if(vasp =3 ,$(vb1),
NUM($(vb1)/$(Vcount),'#,##0.0%')
)))

Kindly help me to resolve the issue. it's urgent

@Anil_Babu_Samineni ,

@Rohan 

@Vegar 

[Swathi]

@GOKULAKANNAN , @Anil_Babu_Samineni 

we have Master Calendar ., created period field, in Period I have YTD and R12M

CYTD and PYTD created in Data Load editor. i am using below, to get common count of customer in cytd and pytd

Count(distinct {1<PYTD={1},CYTD={1},delv_qty={">0"}>} sold_to_desc)

iam getting PYTD count for above not common count of customer.

when i use below formula

Count(distinct {1<CYTD={1},PYTD={1},delv_qty={">0"}>} sold_to_desc )

it is giving CYTD Count, not common count of customers.

I need common count of customers

Example:

tkt year	customer	delvqty
2023	a	10
2023	b	20
2023	c	0
2023	d	40
2024	a	20
2024	b	30
2024	e	60
2024	f	10
2024	c	30

Coommon customer both 2023 and 204

a

b

c

but has 'c' delv qty zero in 2023, need to exclude that customer

Final Output of common customers

a

b

[Anil_Babu_Samineni]

@Swathi Great, So with this, You will be having many more years from "tkt year"?