Activate other graphic tabel with a value from a certain table

[JACKNIEKERK]

please look at sample

having 2 sales years , from separate data tables,  now when i want to compare in 2019 and 2020 the same week(s)  and/or same customer i must double click in both weeks and/of  customer graphs

e.a. week 23 in 2019 i must then also clicked in 2020 week 23 same story with customer choices

how to ativate a script  thats activates same week(s) cliked in 2019 to 2020 ?

Thanks for advise

this is in grafics  statement

OMZET BASED ON IN 2019
sum(Pick(match(UnitTypeVorigjaar,'K','S'), KilosFakVorigjaar * PrijsFakVorigjaar, StuksFakVorigjaar * PrijsFakVorigjaar))

OMZET BASED ON IN 2020
sum(Pick(match(UnitType,'K','S'), KilosFak * PrijsFak, StuksFak * PrijsFak))

[Anil_Babu_Samineni · Accepted solution]

I would suggest to make single week for all years and then define chart like this for different years?

Pie Chart:

Dimension : Year

Expressions are

OMZET BASED ON IN 2019
sum(Pick(match(UnitTypeVorigjaar,'K','S'), KilosFakVorigjaar * PrijsFakVorigjaar, StuksFakVorigjaar * PrijsFakVorigjaar))

OMZET BASED ON IN 2020
sum(Pick(match(UnitType,'K','S'), KilosFak * PrijsFak, StuksFak * PrijsFak))

[JACKNIEKERK]

true, but some practical problems in table by source , (Pervasive based ) that why we must stay to separate tables per year

thanks anyway

[Anil_Babu_Samineni · Accepted solution]

Still you need separate, Create 2 week fileds and 2 pie charts then assign for 1+1 filter and graph as alternate states to work this Here 

[JACKNIEKERK]

during load did connection to 2019 and 2020 table like:

AflKlant as Klantnummer, <<<<<<<<
AflArtNum as Plunr,
AflFlag as Status,
AflbonNummer as Leverbonnummer,
AflAflDate as Leverdatum,
week(Right(AflAflDate,2)&'-'& mid(AflAflDate,3,2)&'-'& left(AflAflDate,2)) as Omzetweek,<<<<<
month(Right(AflAflDate,2)&'-'& mid(AflAflDate,3,2)&'-'& left(AflAflDate,2)) as Omzetmaand,
Date#(Right(AflAflDate,2)&'-'& mid(AflAflDate,3,2)&'-20'& left(AflAflDate,2)) as OmzetDatum,
week(Right(AflAflDate,2)&'-'& mid(AflAflDate,3,2)&'-'& left(AflAflDate,2)) as OmzetweekVorigjaar, <<<<
AflKlant as KlantnummerVorigjaar, <<<<<<<<<<
AflKilos as KilosFak,