bar chart for totals

[rrmcguire]

Hello,

I have a report which has a bar chart which displays the totals of field "dispatchprofit" grouped by month on the change of month then displays the bar chart for each user by their initials "enteredby".

My problem is getting the chart to display the totals for all users in another bar for each user added together?

any ideas?

thanks

 

[lbass]

You should be able to place another chart in the report footer or header where you use month as the on change of field, and then the summary field.

-LB

 

[rrmcguire]

yeah, thats where I have it at currently, I don't believe its the formulas which its using for On Change of and Show Values which are: @MonthB and @DispatchProfit, which shows the values correctly for each personally individually, but not for a grand total of everyone together. The formula itself, @DispatchProfit has nothing being tied in it to any individual user, its generating its values based off of being in the group by the EnteredBy(that user)

When I do put the chart in the report footer it displays the data from the first person in the report broken down by month.

 

[lbass]

Please show the content of the {@DispatchProfit} formula and of any nested formulas.

-LB

 

[rrmcguire]

{@DispatchProfit}= {@Dispatch Net Total MLA} + {@MLT Net Total us}

{@Dispatch Net Total MLA} =Sum ({@Net Total MLA}, {@Month})


{@Net Total MLA}= if {@Status G} = 1 and {@Date Range} = 1 and {SHIPMENTS_TTX.COMPANY} = 'MLA'then {SHIPMENTS_TTX.NET_TOTAL}
else 0


{@MLT Net Total us}=Sum ({@MLT Net Total},{@Month})

{@MLT Net Total} = if {@MLT LineHaul 8%} < {@MLT Net Total i} then {@MLT LineHaul 8%}
else {@MLT Net Total i}


{@MLT LineHaul 8%}=if {@Status G} = 1 and {@Date Range} = 1 and {SHIPMENTS_TTX.COMPANY} = 'MLT'then .15 * {SHIPMENTS_TTX.LINEHAUL}
else 0

{@MLT Net Total i} = if {@Status G} = 1 and {@Date Range} = 1 and {SHIPMENTS_TTX.COMPANY} = 'MLT'then {SHIPMENTS_TTX.NET_TOTAL}
else 0



I've also noticed on the data tab of the chart expert under the advanced button, its showing Date On Chanbge of: Users.TerminalDefault and Shipments.Enteredby, Show: distinctCount of @month

 

[rrmcguire]

what does it matter if "Don't summarize values" is checked or not in the data tab of the chart expert

 

[lbass]

All of these nested formulas are too much to digest. Could you please try to eliminate as many as possible and present this in one or two formulas max? You also did not show the content of the date range and status g formulas.

-LB

 

[rrmcguire]

yeah, I know its kind of messy. Im starting to think the way the tables are linked is not going to allow for this as the main table is linked up by the field "enteredby" which is a per user thing, so that may be the reason the way I have it with the table currently in the footer that its printing the results of the first user rather than the grand total

 

[lbass]

I can't really comment without knowing more about the tables/linking, etc.

-LB