Custom Expression in Bar graph and Cross table

[Sony Hejmady]

Hi,

When I select single or multiple Period in Filter,I will get the foIlowing Result attached for Cross table for that Business.have this custom expression in CrossTable where I am fetching the percentage of Total Item % with following formaulal .

Sum([Total Item Nr]) / Sum([Total Item Nr]) OVER All([Axis.Rows])) as [Total Item %]

Now when I apply the same filter for Period,the Bargraph should show me same result for that Buiness.

Current expression I am using isSum([Total Item Nr] / [total_item_sum]) where[total_item_sum]=Sum([Total Item Nr] which is calculated column.

Please help for Barchart to get proper values as CrossTable as seen in screenshot.