Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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)))
@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)))