Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am trying to make a Chart 100%
Dimensions are eg month and Department Expression is eg sum of sales
I wanted them both to show 100% each and not 100% Total
Can you advise how to do this?
Attached a pic
Try
=Sum(sales) / Sum(TOTAL<month> sales)
Try this:
Sum(Sales)/Sum(TOTAL <Month> Sales)
My Dimensions are Department and Openmonth
The Expression is
=count({1<OpenYear ={2016}>}DCF)
how would i do this?
Thanks
Try this:
=Count({1<OpenYear ={2016}>}DCF)/Count(TOTAL <Openmonth>{1<OpenYear ={2016}>}DCF)