100% Bar Chart Issue

[kmmqlick]

Hi All,

I am facing a problem with 100% Stacked bar chart .I have category filter, when i select  particular category i want to change years(example Cateogory-A only years need to show is 2019-2022 and Category-B only 2020-2023).Please help me to solve this problem.

[Kushal_Chawda · Accepted solution]

@kmmqlick  try below

=if(getfieldseletions([Category]='Category-A',

sum({<Year ={">=$(=min(Year))<=$(=max(Year)-1)"}>}Sales)/sum(total <Year>{<Year ={">=$(=min(Year))<=$(=max(Year)-1)"}>}Sales),

if(getfieldseletions([Category]='Category-B',

sum({<Year ={">=$(=min(Year)-1)<=$(=max(Year))"}>}Sales)/sum(total <Year>{<Year ={">=$(=min(Year)-1)<=$(=max(Year))"}>}Sales),

sum(Sales)/sum(total <Year>Sales)))