Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
hi
try this
sum({$<[%FactTypeID]={1},[Order type code]={3},#>}OrderCounter)
/
sum({$<[%FactTypeID]={1},[Order type code]={3},#>} TOTAL<Month>OrderCounter)