Jump to content

Custom Expression in Bar graph and Cross table

Sony Hejmady

Recommended Posts


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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...