You are definitely headed in the right direction.
Next step, take your logic for the positive growth segments and add them up:
WINDOW_SUM([Account Growing Sa...]) running along Segment.
This will return the value 13,164,663.
You can then create another calculation that gives you the percentage share. The inside would work similar to:
[Account Growing Sa...] / WINDOW_SUM([Account Growing Sa...]). This will return each segments share of all positive growth sales.
Hope this gets you on the right track!
P.S. The color for Grand Totals is formatted separately than the rows and columns, so you won't be able to change the color based on any logic.
It does but I think I failed to mention that I just wanted one combined column for my growth and decline contribution. Your suggestion worked perfectly but I have blanks for the decliners. So I went back and adjusted the calc to an if then statement and now all is good with the exception of 2 additional things.
How can I make the negatives go to the left versus both positive and negatives going to the right?
Also, how can I remove the color coding for the totals? They are interfering with my segment color coding.
Vice President, Analytics & Insights
3701 Algonquin Road
Rolling Meadows, IL 60008 USA
O: 847.342.1095 x 4024
Click our logo to go to our website and join the TPE community!
This message (and attachments) is for intended recipient’s use only and contains confidential information. If received in error, please advise sender ASAP then destroy email so it cannot be shared.
I'm not sure I follow you on the question "How can I make the negatives go to the left versus both positive and negatives going to the right?"
To change the color of the grand total, right click in the grand total area and select FORMAT. You can adjust the appearance in the left-hand pane that just popped up.