Set analysis Calculate Total on bar chart

[#1]

Hello Everyone,

I try to create a bar chart to calculate revenue percentage for each group.The Dimension is Division.

Current Month:

=sum ( {$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {'$(#=Only(_Month))'}, Division= >} [Revenue])

YTD:

=sum ( {$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {"<=$(#=Only(_Month))"}, Division= >} [Revenue])

Is there a way to let the set analysis calculate the total for all Division on this bar chart?

Thank you very much in advance!

[sunny_talwar]

Add another bar for TOTAL? Is that what you are looking for?

[#3]

Thank you - Sunny,

I need a bar chart show (Revenue by Division)/ (Total Revenue of all the Division)

Thanks.

[sunny_talwar · Accepted solution]

Try selecting relative option on the expression tab.

or

this may be:

=Sum({$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {'$(#=Only(_Month))'}, Division= >} [Revenue])/Sum(TOTAL {$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {'$(#=Only(_Month))'}, Division= >} [Revenue])

[swuehl]

Maybe using TOTAL qualifier:

Current Month:

=sum ( {$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {'$(#=Only(_Month))'}, Division= >} [Revenue])

/

sum (TOTAL {$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {'$(#=Only(_Month))'}, Division= >} [Revenue])

[#6]

Thank you very much - Sunny and swuel.

Works perfect.

You guys are great!

You have great day!