Bar chart selection is not happening for one of the dimensions

[KishoreSuri]

Hi Team,

We have a requirement of Bar chart with sum(revenue) and dimension as Month. We are getting all the months bar values in the chart by selecting different dimensions , but when we select one of the dimensions named as Account owner , we are getting only one month (latest month - Mar'19)revenue only. We are expecting for all the months upto Mar'19. Please help us.

Dimension : = if(Match([SN Version], $(vPlanStart)), 'Sales Plan' & $(vPlanSummaryYear), Date(Date#(MonthVersion , 'YYYYMMDD'), 'MMM YY'))

Expression:

1.Amt :- =SUM({$< CoreData={'Core Data'}, ComboGenericName={ 'Actual+Est+Sales Fcst+Plan'}, MonthVersion={">=$(vLatestSNEndOfMonth)"},Year={$(vPlanSummaryYear)}>}Amt)/1000
+
SUM({$< CoreData={'Core Data'},IsSN={1},ComboGenericName={"SN Actual+Est+Sales Fcst*"}, [SN Version] = {">=$(vMaxPlanVersion)"}, Year={$(vPlanSummaryYear)}>}Amt)/1000

2. if((SUM({$< Code={'A','B'}, CoreData={'Core Data'}, IsSN={1}, ComboGenericName = {"$(='SN Plan - ' & vPlanStart)"}, Year={$(vPlanSummaryYear)}>}Amt)/1000)>0,
SUM({$< Code={'A','B'}, CoreData={'Core Data'}, IsSN={1}, ComboGenericName = {"$(='SN Plan - ' & vPlanStart)"}, Year={$(vPlanSummaryYear)}>}Amt)/1000
)

BY USING ABOVE DIMENSION AND EXPRESSIONS WE HAVE CREATED FIRST CHART. 

Dimension and Expression we took as per our requirement and data.

Please help us  how can we get all the months Bars for filter Account Owner

Actual bar chart (without any filter)Filter - Account ownerFilter - ASP1

[KishoreSuri]

Hi Team,

Please ignore the post, we found the issue, there is some mismatch in the data and getting the issue as mentioned in the post.

Thanks.