Relative % in a Bar Chart

[jorditorras]

Hi Gurus, 

I have a Bar Chart were I see the number of orders by category month by month. So, if there are 5 categories, I see 5 bars per month. My calculation right now is:

sum({$<[%FactTypeID]={1},[Order type code]={3},#>}OrderCounter)

that I use as Measure, and in Dimensions I have: Category and Month. 

So, my question is: How can I see the % of orders per category month by month? 

[lironbaram]

hi 

try this 

sum({$<[%FactTypeID]={1},[Order type code]={3},#>}OrderCounter)

/

sum({$<[%FactTypeID]={1},[Order type code]={3},#>} TOTAL<Month>OrderCounter)