Making a Bar chart show 100% per month

[Anonymous]

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

[swuehl]

Try

=Sum(sales) / Sum(TOTAL<month> sales)

[sunny_talwar]

Try this:

Sum(Sales)/Sum(TOTAL <Month> Sales)

[Anonymous]

My Dimensions are Department and Openmonth

The Expression is

=count({1<OpenYear ={2016}>}DCF)

how would i do this?

Thanks

[sunny_talwar]

Try this:

=Count({1<OpenYear ={2016}>}DCF)/Count(TOTAL <Openmonth>{1<OpenYear ={2016}>}DCF)