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 

[GOKULAKANNAN]

Hi Swathi,

Where is the button object you are referring to, and when clicking the button object it should affect only customer behaviour shift object?

[Swathi]

@GOKULAKANNAN , Thanks for the reply, can consider all below buttons, i have attached sample sheet

[GOKULAKANNAN]

In that case, use Set analysis to directly in the button labels, so that it will show the values accordingly irrespective of selections.

[Swathi]

i tried that also but its was interacting with top period filter, i period changing to YTD, R12 M, button alos according to that

[Anil_Babu_Samineni]

@Swathi I always recommend to remove logos from your dashboard (To avoid security reasons).

Now, Can we know what you exactly looking for (Looks good if you can share the needs with screenshot)? 

[Swathi]

i have tktdate, soldtodesc, delvqty field's, i need to calculate common customers falling in current ytd(01-01-2024 to 29-01-2024) and previous ytd (01-01-2023 to 29-01-2023) and volume>0.

How to write expression for these. i tried below but getting error

Count({<Period={'Month-Year'}, tkt_date={"$(PYTD)"},tkt_date={"$(PYTD)"},delv_qty={">0"}>} DISTINCT sold_to_desc)

[GOKULAKANNAN]

Hi @Swathi ,

If you want to calculate seperately, then use this

Count({<Period={'Month-Year'}, tkt_date={$(PYTD)},delv_qty={">0"}>} DISTINCT sold_to_desc)

If you want to include both YTD, then create 2 variables and include it.

[Swathi]

@GOKULAKANNAN , Thanks for the reply, 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

[GOKULAKANNAN]

Hi @Swathi ,

Am not understanding the common count of customers, can you please breif it.