Trying to get Bar chart to show 100% per month

[Anonymous]

Hi All

I am having a slight issue where i cannot get a chart to show 100% total per month

I have attached a quick Demo so no Company data is displayed

I am trying to get my Bar Chart to show 100% per month and not total of 100% over YTD

Please advise what i am doing wrong.

One of those things that's been in my head for ages, i know i've done this before but cannot remember the solution.

Thanks so much

Adil

[swuehl · Accepted solution]

Disable the 'relative' option and use the expression:

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

/ count({1<OpenYear = {'2016'}>} TOTAL<OpenMonth> DCF)

[Anonymous]

Yes! Finally, i have seem what you done and i just change dnumber to percentage and it shows 100%

How simple was that but it done my head in for the whole day!

swuehl Thank you for replying so late....its 22:45 in the UK

Now time for bed